Power BI: How to Analyze Datasets in Excel from Power BI Service

Power BI offers the “Analyze in Excel” feature, enabling users to seamlessly connect to datasets hosted in the Power BI Service and analyze them directly within Excel.

Follow these steps to analyze Power BI Service datasets in Excel using the “Analyze in Excel” feature:

1. Open Power BI Service by navigating https://app.powerbi.com 

2. log in with your credential

3. Navigate to the Workspace where the dataset is located.
   

4. Click on the dataset you want to analyze.

5. Select the More options (…) menu next to the dataset name.

6. Click Analyze in Excel.
   

7. A .ODC file (Office Data Connection file) will be downloaded.
   

8. Open Microsoft Excel.

9. Locate and open the .ODC file you downloaded.

10. Excel will connect to Power BI and load the dataset.

11. You will now see the dataset as an OLAP PivotTable, ready for analysis.
    

12. Use the PivotTable Fields pane to drag and drop fields into rows, columns, values, and filters.

13. Apply filters to refine your analysis.

14. Use Excel formulas and functions for advanced calculations.

15. Create charts or graphs using Excel visualization tools.

16. Save your Excel file to your local system or cloud storage.