User Profile
Speed
Regular Visitor
Joined 6 years ago
User Widgets
Contributions
Gateway - The key didn't match any rows in the table
Hi all, I have a problem with one of our reports. The Report connects to a MySql Database and everything worked well until we added 2 new tables from the same database. From the pbix file the data refresh works without problems but when the Powerbi Service tries to get the data via our on-premise data gateway we get this error: There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these 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":"[Schema = \"<db name>\", Item = \"<table name>\"]"}},{"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\", \"Schema\", \"Item\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: <table name>. The gateway is up to date. I already tried to remove the whole Report incl Dataset and pushed it again, I pushed it to another workspace but nothing fixed the error. When I remove the 2 tables the refresh is working again. Is there some cached data that doesn't recognize the 2 new tables? How can I fix this? Best AlexSolved17KViews0likes7Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.