Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.