Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DM_GWPipeline_Gateway_MashupDataAccessError

Can someone help me understand what this error message is talking about? I saw people suggest checking if the table names in the power .pbix file and table names in the data source match, which they...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I rebooted the server, but that didn't clear the issue either. Instead, I ended up going to the settings for the dataset, going to the Gateways sections changing the On-Prem Dataflows mapping to blank, and changing the cloud Dataflows to a personal connection.

     

     

GilbertQ's avatar
GilbertQ
Super User
2 years ago

Hi Anonymous 

 

This normally happens when your data source has got Keys that are used in relationships are missing. This then causes it to error. I would suggest refreshing the dataset by opening Power BI desktop and see if the error occurs there which will allow you to fix the error.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi GilbertQ 

     

    Thanks for your reply. I was able to refresh successfully in Power BI Desktop. It's only when I try and refresh the dataset in Power BI Serice that I get the issue.

     

    I should note that I have a Power BI Dataflow within the same workspace which the dataset uses in many of its tables as the source. This was working fine a month ago, but then when we updated the gateway we had nothing but issues.

    • Raj_1995's avatar
      Raj_1995
      Regular Visitor
      2 years ago

      Hi, I am also facing the same issue. Please let me know if you found any solution

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        I would suggest taking a look at your dataset's settings in the Gateway section.