Forum Discussion
Dataset and Dataflow refresh problems.
Hello Community,
I'm facing an issue updating a Dataset, it is constantly displaying the "The key didn't match any rows in the table." error, the table is generated through a Dataflow from an SQL Database. The dataflow updates with no problem, however, when we are updating the dataset it pops the error. I can update the Power BI project with no problem from the dataflows, but the automatic refresh on Power BI service always pops that error.
I appreciate your help beforehand.
Below you can find the error details in case it may help.
- 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":"[entity = \"Minerva Ticket_Info\", version = \"\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"entity\", \"dataCategory\", \"Data\", \"Tags\", \"ItemKind\", \"ItemName\", \"IsLeaf\"}, {})"}}],"exceptionCulprit":1}}} Table: Tickets_Info.
- Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
- Activity ID: fca8d839-6ded-471f-aa16-43b3820515e1
- Request ID: e2f26388-26fd-b59c-8fa2-70da738bf9e7
5 Replies
Hey Reigo94 ,
This is from one of two things in my experience - either you are not reaching the gateway and/or the gateway doesn't reach the data. The other issue is that you may have a field that is typed incorrectly (a Data Field that has a non-date in it for example). In this case, the Tickets_info table.
Hey Collinq,
Thank you kindly for replying, I have actually no idea what might be happening, I reviewed the refresh history and pretty much by each time the dataset got refreshed, a new table of the dataset is not available, so it is not constant. I think it could be what you stated that the gateway does not reach the data, however I have no clue how to fix that.
Thank you in advance if you may know a way to overcome this issue.
Hi, Reigo94
Did you change the table structure of your original datasource(table name, column name...)?
Best Regards,
Community Support Team _ EasonI actually didn't, the database table is linked to a dataflow, later to be modified via power query on the dashboard directly.
