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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AlanAr
Frequent Visitor

Object reference not set to an instance of an object

Hello guys.

 

I have a connection and Gateway configured already in Power BI Service with a SAP BW Server datasource.

The scheduled refresh has worked for about a year, however since a week ago,it's been throwing this error:

 

"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Object reference not set to an instance of an object."}}.

 

After trying many times by refreshing manually, it works. 1 in 10 attempts

Also, if I refresh the dataset in powerbi desktop, there's no problem.

And nothing has changed within the gateway or the datasource.

 

Do you have any idea can solver the issue? Can you help me, please?

Thanks!!

3 REPLIES 3
AlanAr
Frequent Visitor

Hi @aj1973 

Thanks for your response, we updated the Gateway to last version today as your suggestion, but it still throws the error.

 

aj1973
Community Champion
Community Champion

Hi @AlanAr 

Did you say that 1 out of 10 attempts the refresh can happen manually in the service? if so then it sounds more like a bug or a troubleshooting issue at the server level.
Where is the Gateway installed? On-Prem or Local machine ?
Can you please try another attempt and Uninstall all Gateways versions, clear all the files containing the Gateway and the re install a brand new version...Try and let me know please.  

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

aj1973
Community Champion
Community Champion

Hi @AlanAr 

Have you updated your Gateway ever since you have installed, If not then it is time to do it.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors