Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Gateway Refresh Data Error: DM_GWPipeline_Gateway_MashupDataAccessError

Does anyone have experience with the below Gateway refresh error message? The table which is referenced, CMS DRG Files, is a Power Query which gets data/files from a folder. This table, along with the others in the pbi file, refresh fine within pbi desktop. However, once the file is uploaded to power bi service and a refresh is attempted, it throws the below error. The gateway connection is fine and all data sources have been allowed through the gateway. 

I tried to rebuild the query within pbi desktop but that did not resolve the issue.

 

Thank you very much for your help,

Tyler

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous 

     

    I can confirm from the error message is that all the file connections are going through the gateway successfully.

     

    The error is because the column "FY 2020.xlsx" cannot be found in the table called "CMS DRG Files"

    This often happens when there is a change to the underlying file and can only be seen after a full refresh of the data.