Gateway Refresh Data Error: DM_GWPipeline_Gateway_MashupDataAccessError

[thaling]

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

[GilbertQ]

Hi @thaling 

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.