Forum Discussion

CCal's avatar
CCal
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Shared semantic model not appearing in Excel

Hello,    Can anyone shed light into what permissions exactly is needed to allow an user to load a semantic model into their excel? And how long does it take for the permissions to propogate?   ...
  • v-veshwara-msft's avatar
    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 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.