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

[DebbieE]

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

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?

[lbendlin]

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

[DebbieE]

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

[lbendlin]

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]

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.