Forum Discussion
Solved
Not all semantic models available in Excel
Problem: Users are trying to connect to PowerBI semantic model from Excel but are not seeing all the models they have access to Symptoms: Users have View permissions to the Workspace and Build per...
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.
Have you checked the following Prerequisites. I guess one of these three could be missing.
- 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 semantic models, 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 a Power BI license: Fabric Free, Pro, or Premium Per User (PPU). Fabric Free license users can only work with semantic models in My workspace or a Power BI Premium capacity or Fabric F64 or greater capacity. Learn more about Power BI licenses.