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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
DebbieE
Community Champion
Community Champion

error:[codes:”DM_GWPipeline_Gateway_MashupDataAccessError”,”pbi.error: After some data moved to Azur

Ive been asked to help with an issue with an error (Unfortunatly they wont let me have actual access to the Power BI App Workspace which makes things incredibly difficult

 

MashupError.JPG

This happens to their List table which is in Excel and because its on premise they use an Enterprise Data Gateway

they have identified where it errors in service

 

  #"Appended Query" = Table.Combine({#"Replaced Value", #"NewList"}),
 
So NewList is a table in Azure so doesnt need the Enterprise Gateway because its in the Cloud
 
So apparently if you take this out. Its all fine. Add it back in and you get the above error
 
Im struggling a bit because of not having access to the App Workspace. What can I do to try and resolve this for them?
4 REPLIES 4
lbendlin
Super User
Super User

How long does it take to retrieve "#Newlist" by itself?  Can you speed up that query on the Azure database?

DebbieE
Community Champion
Community Champion

I dont think thats the issue.

 

Apparently it doesnt take more than a few seconds to run. Its specifically an issue with the Gateway and I need to know the best route of getting it fixed

how many cluster members in the gateway? How busy is the gateway with other stuff? How much memory do the cluster members have? are they on version 45.7 ? Can you reboot them all?

DebbieE
Community Champion
Community Champion

how many cluster members in the gateway? How busy is the gateway with other stuff? How much memory do the cluster members have? are they on version 45.7 ? Can you reboot them all?

 

All good questions, Im hoping to get some time with the admin very soon. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors