Forum Discussion

Charles3's avatar
Charles3
Regular Visitor
1 year ago

Excel failed to connect to the Semantic Model.

Hey guys,

 

Since the beginning of the month I have been having problems with spreadsheets connected to the Power BI dataset (Semantic Model). I'm referring to the "Analyze in Excel" option, available in the Power BI service for the dataset.

 

When clicking on update data, the authentication screen - to enter email and password for the dataset - opens several times.

 

After entering email and password, it apparently connects, but remains in a connection attempt loop.

 

Anyone going through this?

 

 

 

Need Help

6 Replies

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Icon for Super User rankSuper User
    1 year ago

    Can you try with different semantic models? maybe one from your My Workspace. 

    2 reasons i can think of:
    1. If the workspace is on Fabric capacity, it may be throttled. Check if My workspace connection works.

    2. Your Fabric tenant disabled Analyze in excel

  • Charles3's avatar
    Charles3
    Regular Visitor
    1 year ago

    For datasets in other Workspaces it gives the same problem.

    On the authentication screen, after the fifth time entering email and password, it sometimes connects and updates.

    But there are times when we do this routine several times and it doesn't connect.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for the reply from Tutu_in_YYC.

     

    Hi Charles3 ,

     

    Based on the screenshot you provided it is clear that your connection string is MSOLAP.8.

    Try changing the connection string from MSOLAP.8 to MSOLAP.7.
    Here is a link with a similar problem, some users have bypassed repeated authentication prompts this way:

    Solved: Re: Frequent Re-sign In Required with 'Analyze in ... - Microsoft Fabric Community

     

    Best Regards,
    Zhu

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

    • Charles3's avatar
      Charles3
      Regular Visitor
      1 year ago

      Thanks for the help.

       

      But I didn't find MSOLAP.7 to download.

       

      Any tips?

       

      I also noticed that PCs with Windows 11 worked.

       

      Most PCs that use the Excel connection and fail are Windows 10 Pro.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Charles3 ,

         

        I've boxed in the screenshot you gave, you can just change it here, if it reports an error, drop downand remove “Catalog Rebound=True;” from the connection string and save, you won't need to log in again next time you open it.

         

        Best Regards,
        Zhu

         

        If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.