Forum Discussion
Memorable MemberDataset refresh failure - DM_GWPipeline_Gateway_MashupDataAccessError
Advocate IIThis might be related to this issue reported a couple of days ago if it used to refresh and has now stopped with no changes.
Memorable MemberIt is impossible to say unless I can dig into the logs.
Unfortunately when I'm using the Power BI service, all I can do is see the message above ("we're sorry something bad happened.").
- dbeavon3
It was only possible to find the true underlying reason for this error message by reading the gateway logs. Microsoft needs to make those available to the people who need them. The admins in our environment do not necessarily want to participate in the troubleshooting of every failing dataset-refresh.
Same problem now in Nov 2023. My reports were refreshing well until some update recently has left me with same problem but no answers!
- dbeavon3
Hi jen15
I've been working with Power BI for a few years. Unfortunately I've come to accept that the enterprise gateway was built in a way that requires PQ developers to also be able to monitor and administer the gateway.
For many types of PQ failures, you must enable advanced logging and read the output, after your refresh has failed.The best way to think of the Power Query language, is as a primitive programming language. Unlike most programming languages which present errors to you directly, PG's error messages are trapped locally on the "gateway" server in the "advanced" logs. If you go ahead and open a ticket with CSS about the failures, they will immediately ask your gateway administrator to enable advanced logs and share the output. In the case that you are not the gateway administrator yourself, these cases take a lot longer than reasonable.
Until Microsoft finds a way to present PQ failure messages to dataset owners, you will need to be a gateway admin yourself, or work closely with a gateway admin to see the underlying errors
