Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

robd1487

Error Refreshing Excel Connection to Dataset

Submitted by Advocate I on ‎10-15-2020 08:11 AM

Currently have an issue refreshing an excel file that has been connected to a Power BI dataset for past 18 months. Error messages are shown below. I have other excel files with dataset connections in other workspaces and they refresh without issue. Any help/suggestions are appreciated.

 

MicrosoftTeams-image (3).png

 

MicrosoftTeams-image (4).png

 

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎10-15-2020 09:56 PM

Recently they released a new version of the connection that no longer downloads an .odc file but is a standard .xlsx file. If your excel file was built off of the previous .odc connection, re-download the dataset's "Analyze in Excel" file, which will be an .xlsx file. Then copy this sheet into your old file with the previous connection. Choose to override the connection and it will update to the new file connection format. This is what worked for us when we encountered this after the update to Analyze in Excel.

 

This also has to do with the fact that sensitivity labels/privacy settings now confer with the Analyze in Excel feature if utilized (usually in a premium workspace).

 

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

 

Idea Statuses