Forum Discussion
Not all semantic models available in Excel
Following up on this: Giving Build permissions was the key. The people that couldn't see the models were simply not hitting enter when searching for the name so it was just showing models they were already using. Sometimes it's the simple things.
Hi BGarrigus ,
Based on your scenario, the main point is that Analyze in Excel and the Excel From Power BI Fabric connector work in different ways and follow different requirements. Since Analyze in Excel is working, it means users already have Build permission and access to the semantic models.
But when connecting from Excel using live connection, there are some extra things that must be enabled. These include the tenant setting Users can work with Power BI semantic models in Excel using a live connection, having the correct Power BI license like Pro PPU or Premium access, and in some cases enabling XMLA endpoint or Analyze in Excel related settings.
If any of these are not set properly, users may still be able to use Analyze in Excel from Power BI service but will face issues while accessing models directly from Excel. I suggest checking these settings in Admin portal and also verifying license and capacity for those users and workspaces.
Refer these docs -
https://learn.microsoft.com/en-us/power-bi/collaborate-share/office-integration/service-analyze-in-excel
https://learn.microsoft.com/en-us/power-bi/admin/service-admin-portal
https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools