Forum Discussion
Initialisation of data source failed error
I have built an Excel report using a Power BI pivot table as a data source. When I refresh this excel file it updates as expected. However, when my user refreshed the file they recieved the foll...
The power BI report is refreshed by refreshing within the desktop app and then re-publishing the PBI Desktop file.
If you try connecting from scratch does that refresh ok?
Someone here suggested a filter or column name might have changed datatype or name.
This isn't flagged by excel until the refresh happens.
Unfortunately doesn't seem to be the issue.
I can refresh the file with no problems, so it's not an issue directly with the file - but something on the user end. I also have other users that can use these files so it shouldn't be a tenant setting (although I'm checking those anyways).
Apparently the user gets the error every couple of minutes they have the file open.