Forum Discussion
Analyze in excel, users accessing through APP
Was there any recent global change? I have lots of users losing the ability to AnalyzeInExcel:
What could be causing this?
(I am not talking about workspaces, I talk about a live report on an App, and users acessing only through the App)
Hi. Let's validate the requisites for the feature:
- 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 Power BI 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.
If you are ok with the requisites check the considerations and limitations of the feature: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#considerations-and-limitations
I hope that helps
1 Reply
Hi. Let's validate the requisites for the feature:
- 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 Power BI 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.
If you are ok with the requisites check the considerations and limitations of the feature: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#considerations-and-limitations
I hope that helps