Forum Discussion
Shared semantic model not appearing in Excel
- 1 year ago
Hi CCal ,
Thanks for using Microsoft fabric Community,
To see a semantic model in Excel, the user must have Build permission. Read permission alone isn’t enough for the model to appear in Excel, even if it’s visible in the Power BI service.This is from Official Documentation
Permission propagation usually takes a few minutes, but due to Excel token caching and background refresh behavior, it can sometimes take several hours to reflect.
Regarding older models reappearing:
These may appear due to local Excel cache refreshing or re-authentication events. If Excel detects cached metadata or if the user signs in after a long period, previously hidden or stale datasets from "My Workspace" might appear.
Also, please ask the user to try searching for the semantic model by name in Excel's Power BI dataset connector, and make sure they press Enter after typing. This has resolved similar visibility issues for other users, as mentioned here:Solved: Excel connection to some semantic models not worki... - Microsoft Fabric CommunityIn another case, the issue was resolved by enabling the "Use datasets across workspaces" setting in the Power BI tenant settings.
Reference: Solved: Dataset not visible in Excel/Power BI Desktop - Microsoft Fabric CommunityLastly, there is an active Known Issue regarding Excel connectivity with semantic models. As a workaround, please try signing out and back into Excel and using a version earlier than 2409.
Hope this helps. Please reach out for further assistance.
Please consider marking the helpful reply as Accepted Solution to assist others with similar issues.
Thank you.
Hi CCal ,
Thanks for using Microsoft fabric Community,
To see a semantic model in Excel, the user must have Build permission. Read permission alone isn’t enough for the model to appear in Excel, even if it’s visible in the Power BI service.
This is from Official Documentation
Permission propagation usually takes a few minutes, but due to Excel token caching and background refresh behavior, it can sometimes take several hours to reflect.
Regarding older models reappearing:
These may appear due to local Excel cache refreshing or re-authentication events. If Excel detects cached metadata or if the user signs in after a long period, previously hidden or stale datasets from "My Workspace" might appear.
Also, please ask the user to try searching for the semantic model by name in Excel's Power BI dataset connector, and make sure they press Enter after typing. This has resolved similar visibility issues for other users, as mentioned here:Solved: Excel connection to some semantic models not worki... - Microsoft Fabric Community
In another case, the issue was resolved by enabling the "Use datasets across workspaces" setting in the Power BI tenant settings.
Reference: Solved: Dataset not visible in Excel/Power BI Desktop - Microsoft Fabric Community
Lastly, there is an active Known Issue regarding Excel connectivity with semantic models. As a workaround, please try signing out and back into Excel and using a version earlier than 2409.
Hope this helps. Please reach out for further assistance.
Please consider marking the helpful reply as Accepted Solution to assist others with similar issues.
Thank you.
- CCal1 year ago
Advocate I
Hello v-veshwara-msft
Thank you very much for the suggestions. I will keep these in minds for troubleshooting.
Especially siging in and out of Excel.
I have spoken to Microsoft support agent and we did some tests, what we found out is that Read and Write permissions are needed, Build permissions wasnt needed.