cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deanbland
Helper III
Helper III

Error messages when refreshing data

Hi,

 

So I am pulling my hair out trying to figure out what is going on with my report. Every time I try and refresh the data, I am first presented with the error message below

deanbland_0-1613744723394.png

 

 

... and then presented with these two errors on multiple queries: 

- OLE DB or ODBC error: Object reference not set to an instance of an object..

- OLE DB or ODBC error: Exception from HRESULT 0x80040E4E

 

All of my data comes from a sharepoint site containing Excel files (xlsm, xlsx, xls), I have gone throygh each data type to make sure they are correct and am now unsure what else to do. It seems that everytime I manage to fix one error, another pops up.

 

Unfortunately I am unable to share the report as it has a lot of sensitive data within it. There is bit of the code from the error, but it was so large I couldn't post it all. 

 

Any help would be greatly appreciated! 

 

Thanks

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @deanbland 

Your data sources are Excel files from sharepoint site.

You can try to get data by web by file link, the steps are the same as getting data from Onedrive.

3.png

Find your excel in document in sharepoint site and open it in app.

1.png

Copy link in info in File.

2.png

Paste the link into web connection in power bi desktop and remove ?web=1 in the end of link.

Sign in by your account which has access to sharepoint.

And I try to refresh in desktop, it works well.

For more details, you may refer to this blog: Use OneDrive for Business links in Power BI Desktop

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

3 REPLIES 3
RicoZhou
Community Support
Community Support

Hi @deanbland 

Your data sources are Excel files from sharepoint site.

You can try to get data by web by file link, the steps are the same as getting data from Onedrive.

3.png

Find your excel in document in sharepoint site and open it in app.

1.png

Copy link in info in File.

2.png

Paste the link into web connection in power bi desktop and remove ?web=1 in the end of link.

Sign in by your account which has access to sharepoint.

And I try to refresh in desktop, it works well.

For more details, you may refer to this blog: Use OneDrive for Business links in Power BI Desktop

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

pranit828
Super User
Super User

Hi @deanbland 

I have had this issue before and the step i took is to loose the file/folder in the folder 

Documents\Power BI Desktop\Custom Connectors

 

Delete or backup a copy in another location if you have something here.




PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
amitchandak
Super User
Super User

@deanbland ,Log an issue too -https://community.powerbi.com/t5/Issues/idb-p/Issues

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.