Forum Discussion
Couldn’t load the data for this visual
I have a PBIX importing data from an Analysis Services database and an Excel file. Most people can open the file and view the reports with no issue. However, there is one manager who gets this error on every visual when they open the file, even without refreshing the data:
Couldn’t load the data for this visual: No OLE DB Error Information found.
They can see all of the imported data in the Data view and in the query editor and they can see the schema in the Relationships view. They just cannot see any of the visualizations, just the gray squares with "Cannot Display the Visual" where they should be.
He has uninstalled and reinstalled Power BI Desktop and is running the latest version. Any ideas?
4 Replies
- fhill
Resident Rockstar
It sounds carzy, but is the Excel file on a network share? Does this one user have the same drive letter mapped as everyone else? I had issues recently where one of my users didn't have a Z: drive and it cause weird problems...
FOrrest
v-jiascu-msftMicrosoft Employee
We had come across that thread and confirmed that the PBIX has all of the data imported into it. Resultantly, the file size is 40 MB. The manager can see the data when they look in query editor or in the "Data" tab on the left, just none of the visuals render. No one else is having this issue when they open the file, which is why we're stumped.
The Excel file is on a network share, but we used the full path in the data source settings, so it doesn't seem to be a mapped drive issue. There are people who do not have access to the network path or the database, but they are able to open and view the visuals off of the data that's already in there, they just cannot refresh. This person cannot get the visuals to load even off the data that's already in there.
- v-jiascu-msft
Hi MP704,
Could you please upgrade his/her Power BI to the latest version? (2.48.4792.721 64-bit (July 2017))
Best Regards!
Dale
