Go to the workspace containing your Power BI dataset or report, select More options (. Select Export > Analyze in Excel from the top ribbon.

In the Power BI service, you can use any of the following Analyze in Excel entry points to create an Excel workbook: With Analyze in Excel, you can create an Excel workbook containing the entire dataset for a specific Power BI report and analyze that dataset in Excel using PivotTables, Pivot Charts, and other Excel features. In the Power BI service, use the following two features to create an Excel workbook:

Power BI provides you with options to ensure that you can extract the right granularity of data depending on how you want to analyze that data in Excel, either with Excel PivotTables or Excel tables.

You can use Excel workbooks containing refreshable Power BI data in both Excel Desktop and Excel for the web.Ĭhoose Power BI data to evaluate in Excel.

Power BI Free license users can only work with datasets in My workspace or a Power BI Premium capacity.

You must have a Power BI license: Free, Pro or Premium Per User (PPU).

You must have Build permission to the Power BI dataset or have at least a Contributor role in the Power BI workspace containing your dataset.

Learn more about the Allow XMLA endpoints tenant setting in the admin portal documentation.

For on-premises datasets, your organization’s tenant administrator also must enable the Allow XMLA endpoints and Analyze in Excel with on-premises datasets tenant setting.

Learn more about the Excel live connection tenant setting in the admin portal documentation.

Your organization’s tenant administrator must enable the Users can work with Power BI datasets in Excel using a live connection tenant setting.

That way, you can focus on your analysis in Excel and be confident that you are working with up-to-date data. In this article, you learn how to create Excel workbooks containing connected Power BI data that you can refresh directly inside the workbook. When you view reports in the Power BI service ( ), you might want to further enrich the report data with additional assumptions, perform what-if analysis, or validate the numbers in a specific Power BI visual or an entire Power BI report.

Power bi for macbook download