Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Charles3
Regular Visitor

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?

Charles3_0-1729177311206.png

 

 

 

6 REPLIES 6
Anonymous
Not applicable

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.

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
Not applicable

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.

vlinhuizhmsft_0-1729761673971.png

vlinhuizhmsft_1-1729761983007.png

 

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.

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
Regular Visitor

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
Super User
Super User

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.