

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.
