Power BI – Excel Integration
Power BI and Excel Integration use to make connections between Power BI Files and Excel Files. If the user wants to see data of Power BI in excel files then he can analyze and see this data in excel.
Following are steps to perform Integration of Power BI with Excel:
Step 1: Open the Power BI Workspace and select create data. Next Click to Paste or manually enter.
Step 2: It will show the following Interface. now enter data in rows in columns respectively whatever you want and Click to create a report.
Step 3: It will show Report is created and Based on the data entry it will analyze using Power BI Function and Graphics. Check the results.
Step 4: Now Click on Export Option and select analyze in excel and click.
Step 5: It will Show Excel is ready. Now Click on Open in Excel for the web.
Step 6: In the next window, it will show one alert. Simply select Yes.
Step 7: Now Our Excel is integrated and it is ready to see data in an excel file. Click on any column name and it will show respective data . Here we are selecting the City column.
Step 8: If we want to change row data into a column we can change it by selecting and entering both names in the column box.
In this above way, we can do Integration of Power BI and Excel.
Contact Us