Forum Discussion
PowerBI Scheduled Refresh Crashes on Dataflow
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}}}
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.
3 Replies
- YIAXFrequent Visitor
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.
- AnonymousNot applicable
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