Error 'object reference not set to an instance of an object' when refreshing data in powerBI desktop

[abrouwer]

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! 

[JulianNoarmenn]

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-o...

[v-luwang-msft · Accepted solution]

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:

https://community.powerbi.com/t5/Issues/Task-s-exception-error-thrown-when-setting-up-incremental/id... 

https://community.powerbi.com/t5/Desktop/Object-reference-not-set-to-an-instance-of-an-object/td-p/2... 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[lbendlin]

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/