Breyta

Deila með


Connect Excel to Power BI semantic models

Microsoft Excel is arguably the most common data analysis tool for information workers and organizations across the globe. Part of Excel’s appeal is that you can start your data journey in a few clicks, with quick calculations, data visualizations, and ad-hoc analysis.

You can discover, connect to, and explore centralized Power BI data inside the spreadsheet grid of Microsoft Excel. The versatility of Excel and the unified governance and security standards of Power BI ensures you're using the right data to make better decisions that support business goals and fosters an enhanced data culture.

Screenshot of Power BI semantic models in Excel.

Access Power BI semantic models in Excel

When you access Power BI semantic models in Excel, the semantic models inherit properties. Inherited properties, like endorsement labels and sensitivity labels from Microsoft Purview Information Protection, help make sure that the data stays secure. Semantic models tagged with the labels Certified or Promoted are likely to be better quality and more authoritative than semantic models without a label.

Connect to Power BI semantic models in Excel by starting in the Power BI service or in Excel for the web or the Excel desktop app.

Prerequisites

Here are things to keep in mind when you connect to Power BI semantic models in Excel:

  • Your organization’s tenant administrator must enable the Users can work with Power BI semantic models in Excel using a live connection tenant setting. Learn more about the Excel live connection 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 Allow XMLA endpoints tenant setting in the admin portal documentation.
  • You must have Build permission to the Power BI semantic model or have at least a Contributor role in the Power BI workspace containing your semantic model.
  • You must have a Fabric license: Fabric (free), Pro or Premium Per User (PPU). Fabric free license users can only work with datasets in My workspace or a Power BI Premium capacity or Fabric F64 or greater capacity. Learn more about Power BI licenses.
  • You can use Excel workbooks containing refreshable Power BI data in both Excel Desktop and Excel for the web.