Forum Discussion

YIAX's avatar
YIAX
Frequent Visitor
1 year ago
Solved

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}}}

  • YIAX's avatar
    YIAX
    1 year ago

    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