Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
6 years ago

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

 

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?
Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

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

    • DebbieE's avatar
      DebbieE
      Community Champion
      6 years ago

      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's avatar
        lbendlin
        Super User
        6 years ago

        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?