Ever since about 6am Eastern today, my dataflow refreshes have been just spinning - no errors, just spinning like it's trying to load the data.
41 Comments
- jmlove0923Frequent Visitor
Same - problem for us started at 5:30am Eastern. Prior to that they worked. Datasets on non premium capacity workspaces work but all premium workspaces Dataflows faile while their dataset refreshes are fine. BTW this happened on Wed too.
- NatashaCRegular Visitor
We have been expereincing refresh issues with some of our Power BI reports as well. I got the below email notification
{"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":"<pi>Microsoft SQL: A severe error occurred on the current command. The results, if any, should be discarded.</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"cldaxsql7\\bi;Datawarehouse"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"A severe error occurred on the current command. The results, if any, should be discarded."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"0"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Orders.
With a manual refresh the datasets just spins.
- allykleeAdvocate I
I put in a ticket...
- edhansCommunity Champion
Yup. Down for me too.
- ttrotter785Regular Visitor
Down here. Same thing happened last Friday morning. By the afternoon everything was magically working again, but this is frustrating.
- ccconleyFrequent Visitor
Same here. Data flows are just spinning and never finishing. The jobs usually take 6 minutes to load and now has been runing for serveral hours. Have to cancel the refresh.
- edhansCommunity Champion
Things seem to be working for me better right now. Anyone else seeing a recovery?
- JeffreyalbrightRegular Visitor
Still not refreshing on my end..
**We have submitted a ticket for the issue.
- derrickloRegular Visitor
Workspace "IP12d TEST" return incorrect data "petal.length", not using my Dataflow supplied
Hi,
I was using the AutoML in Power BI, initially it worked for 5 features. When I increase the features selected to 15, it returned incorrect results.AutoML returned result for "petal.length", instead of "CusSalesAmt" - seems it is not using my Dataflow supplied!
My test data is about customer sales amount, nothing to do with flowers, petal length, and species.
My Workspace "IP12d TEST" does not work, Workspace "IP12f TEST" is working - but the Model Performance is very low at 31%, was trying to improve it!
Please help,
Derrick - rflamencoAdvocate I
I am also having an issue with dataflows refreshing. Refreshed sucessfully at 6PM CST yesterday. This moring at 6AM CST, refresh started and ran for 10 hours before manually cancelled.