![]() This result is fetched live from the Power BI dataset in the Power BI service. PivotTable in Excel presenting Power BI dataset’s dataĭrag data fields into the slicing and dicing area (right under the fields pane), and you will see a result in PivotTable. Analyze in Excel will use the same Power BI account username and password that you had access to the report from it (because the Power BI account is an Office 365 account). Once you click Yes, you will see an Excel workbook with a PivotTable, which is the data sourced from the Power BI dataset in the service. Once you open the file, you will get a warning about the data coming from outside of this workbook (Power BI Dataset) Data coming from outside of the Excel workbook However, you can download the file and store it locally. The opening of this file, by default, is in Excel online (web version). (If you don’t have OneDrive for Business in your tenant, then clicking on Analyze in Excel will download the workbook to your local computer) Opening Analyze in Excel You will get a notification when the Excel file is ready. Power BI will generate an Excel file in OneDrive and create a connection from that Excel file to the Power BI dataset. Analyze in Excel from Power BI report or dataset Log in to the Power BI service and click on the more options of a dataset (or a report). You can initiate the Analyze in Excel from a Power BI Service report or a dataset. Now let’s see how Analyze in Excel works in action. The connection to the Power BI dataset would be a live connection, which means whenever users refresh the Excel file, they will get the most up-to-date data from the Power BI service. ![]() Excel users can still use Excel to connect to the Power BI dataset and use Excel features such as PivotTable and PivotChart to slice and dice the data. Every company will find some users with very good experience and skillset in Excel. ![]()
0 Comments
Leave a Reply. |