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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

robd1487

Error Refreshing Excel Connection to Dataset

Submitted by 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
Ali_Sabzevari
Regular Visitor
‎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