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.

Data analysis excel mac