Forum Discussion
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 not make any changes to the dashboard. I have never had an issue refreshing the data before. Not sure how to solve. Thanks!
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
3 Replies
- lbendlin
Super User
You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/
- v-luwang-msft
Community Support
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/
