PowerBI Scheduled Refresh Crashes on Dataflow

[YIAX]

I have a scheduled refresh crashing on a report that is contains a gateway and cloud connection (data flow). Manually refreshing the data in the desktop app works fine, but when refreshing in the workspace it consistently crashes. I recieved the following error with a workspaceID linking to the dataflow. Which makes me believe that the dataflow is the problem but I do not see any issues with the data at all. I have Allow user's cloud data sources to refresh through this gateway cluster enabled.

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":"[workspaceId = \"removed for privacy\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"workspaceId\", \"workspaceName\", \"workspaceType\", \"Tags\"}, {})"}}],"exceptionCulprit":1}}}

[Anonymous]

Hi @YIAX ,

Whether the advice given by lbendlin  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

[lbendlin]

https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-...

[YIAX · Accepted solution]

I actually ended up recreating the report and then testing the upload on my development gateway and it seems to be working. I think my issue is that the gateway in my other environment must be out of date.