Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
abrouwer
New Member

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! 

 

abrouwer_1-1655326961702.png

 

 

 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

 

Hi @abrouwer ,

Some user feedback.If you use this setting it goes through the error:

 

vluwangmsft_0-1655801924226.png

 

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

View solution in original post

3 REPLIES 3
JulianNoarmenn
New Member

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
Community Support
Community Support

 

Hi @abrouwer ,

Some user feedback.If you use this setting it goes through the error:

 

vluwangmsft_0-1655801924226.png

 

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
Super User
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/

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.