Forum Discussion
Solved
Error 'object reference not set to an instance of an object' when refreshing data in powerBI desktop
I am getting the below errors when I click "refresh" on my power BI desktop dashboard. The data is linked to one excel file. I updated the data in the excel file the same way I do every week and did ...
Hi abrouwer ，
Some user feedback.If you use this setting it goes through the error:
And you could try to use previous monthly version to have a test.
https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive
simiar question refer:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Short answer
For anyone having the same problem with Excel files, check the following items:
- Latest version of Power BI Desktop
- Use the beginning of the URL with https
- Update WebView2 to latest version
- Resave spreadsheets that may be corrupted
Long answer
Read here: https://powerbipoint.com/2024/01/02/power-bi-fix-the-error-object-reference-not-set-to-an-instance-of-an-object/