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, availa...
Need Help
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.

      • Charles3's avatar
        Charles3
        Regular Visitor
        1 year ago

        thanks for the help.

         

        However, it didn't work.

         

        When I delete this part of the connection and click save, the authentication request continues in a loop.

         

        When analyzing the connection string again, this information, which I had deleted, appears again in the file.