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
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.