Forum Discussion
User Can Connect Semantic Models with Power BI but Can Not Connect with Excel
Hello,
We are experiencing an issue while connecting Semantic Models with Excel. Below are the details:
-The user has build access to all semantic models (granted via sharing apps).
-The user can successfully connect to these semantic models and view them in Power BI.
-However, when trying to connect to the semantic models in Excel, only one semantic model appears.
Could you please assist us in resolving this issue?
Hi anilelmastasi ,
Please check the prerequisites before 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.
For reference: Connect Excel to Power BI semantic models - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hello Fowmy ,
The Entire Organization option is selected by default. Does this mean that there shouldn't be any issue from this setting?
Hi anilelmastasi ,
Please check the prerequisites before 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.
For reference: Connect Excel to Power BI semantic models - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
