Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError
Hi!
I have a Semantic Model where refresh works fine in Power BI Desktop and it works fine to refresh in the Service with our production Gateway with version March 2024. But when I refresh the same model using our test Gateway with version August 2024 i get the error message below. Is this a bug in the August version or can it be something else?
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 = \"DREPCUR\"]"}},{"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}}}
Regards
Fredrik
1 Reply
- AnonymousNot applicable
Hi FredrikJ
The error message you’re seeing, "DM_GWPipeline_Gateway_MashupDataAccessError", typically indicates a problem with data access during the refresh process. Please try to check the following:
1. Ensure that there have been no changes to the data source or credentials between the production and test environments. The error message “The key didn’t match any rows in the table” suggests that the query might be looking for a value that doesn’t exist in the test environment.
2. Verify that the gateway is configured correctly and try reconfiguring the data source credentials.
3. Restart the data source and gateway servers.
These similar cases are for your reference:
Solved: Refresh failing in online but working in desktop v... - Microsoft Fabric Community
Solved: Refresh fails on online service but works in deskt... - Microsoft Fabric Community
Solved: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Fabric Community
Solved: Data Source Error - Microsoft Fabric Community
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.