Excel failed to connect to the Semantic Model.

[Charles3]

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?

[Anonymous]

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]

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]

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]

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.

[Charles3]

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.

[Tutu_in_YYC]

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