Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
mina_ann
Regular Visitor

Power BI Refresh ERROR - DM_GWPipeline_Gateway_MashupDataAccessError

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
2 REPLIES 2
v-linhuizh-msft
Community Support
Community Support

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

rajendraongole1
Super User
Super User

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.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors