Forum Discussion
Error message: DM_GWPipeline_Gateway_MashupDataAccessError
Hi there, when I update the dashboard in the desktop version, I have no ptoblem. When I try to update in Service, this error appears. The mentioned Table in the Error "Lagerort_AK" is a .txt file...
I stopped importing the .txt file and instead used the data input in PowerQuery. Now the append query works fine. This only works because the .txt is a static file that normally never changes. Another Solution was not found actually or what was the exact root cause of the failure
For Power BI to access your Excel file you need to set up a connection in the Power BI gateway, did you do that?
Also make sure the Power BI gateway is updated to the latest version:
my problem is the .txt file as I wrote above. and yes all other sharepoint excel data is imported correclty - also in all my other dashboards