March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am able to refresh my import model in desktop and in our Development server.
However after deploying to Test (which points to our test oracle server), I now get this DM_GWPipeline_Gateway_MashupDataAccessError when I try to refresh.
The interesting note is the few times I've tried I get a different table at the bottom of the error each time:
Last refresh failed: 10/9/2024, 9:36:08 AM
There was an error when processing the data in the dataset.Hide details
Data source error: | {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The key didn't match any rows in the table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Name = \"EARN_CD_D\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: Earnings Element. |
Cluster URI: | WABI-WEST-US-redirect.analysis.windows.net |
Activity ID: | 1acc7a75-f2e4-460f-a33e-213de5332257 |
Request ID: | ca8ec341-a91a-994a-9484-33ee13ca944b |
Time: | 2024-10-09 16:36:08Z |
Thanks for the reply from rajendraongole1.
Hi @mina_ann ,
Have you solved your problem? If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster. Thank you very much for your kind cooperation!
Best Regards,
Zhu
Hi @mina_ann - The error you are encountering, DM_GWPipeline_Gateway_MashupDataAccessError, is often related to issues with data source connectivity or the schema changes in the database when refreshing Power BI reports through a gateway
solved threads:
Solved: DM_GWPipeline_Gateway_MashupDataAccessError error ... - Microsoft Fabric Community
Solved: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Fabric Community
Hope this helps.
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
38 | |
37 | |
32 | |
20 |