Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError On-Premises Data Gateway Error
Helper IIThis is to let everyone know that our issue stopped being an issue on September 1, 2020 when refreshes started working again without errors (almost a month after they first failed). However, if it helps anyone to troubleshoot in the future, we identified another workaround along the way.
- Our sources were SharePoint on-prem lists that were appended as part of the M query in Power BI.
- They were all in sub-sites of one parent site and there was one gateway connection to the parent site.
- After the report failed to refresh with Append, we tested that lists could still be refreshed individually (without appending) using the above gateway connection.
- The workaround, though, was to create a gateway connection per each sub-site/source (using the same account and password, so no change in SharePoint, only several new gateway connections created instead of one).
- Then each list was mapped to its own gateway connection and with that, the refresh of the report with appended lists worked - that was a more acceptable temp solution for us as it didn't require any changes inside the report.
Hi OB ,
It's glad to hear that the refresh start working. Thanks for your reply and sharing your solution. There are some threads about this type of problem which schedule refresh can't work properly due to the append query. There is no good solution yet. Your solution may help people who have similar problem. Could you please just mark your last post as Answered? It will help the others find your solution easily and fast. Thank you.
Best Regards
Rena
- OB
Anonymous , please send me a snapshot how to mark the post as Answered 😂 The very first post in the thread wasn't mine, though. In addition, there were two workarounds, one Union in DAX and one gateway connections, so both should be marked as solutions, even though I would still call them workarounds.
Thank you!
Hi OB ,
Please check if there are two buttons ("Reply" and "Accept as Solution" button) which are same with the ones in below screenshot under each reply in your thread? You can click the "Accept as Solution" button to mark your two workarounds as solutions.
Best Regards
Rena