Dataflows

[Jeffreyalbright]

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.

[jmlove0923]

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.   

[NatashaC]

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. 

[allyklee]

I put in a ticket...

[edhans]

Yup. Down for me too.

[ttrotter785]

Down here.  Same thing happened last Friday morning.  By the afternoon everything was magically working again, but this is frustrating.

[ccconley]

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.

[edhans]

Things seem to be working for me better right now. Anyone else seeing a recovery?

[Jeffreyalbright]

Still not refreshing on my end.. 

**We have submitted a ticket for the issue.

[derricklo]

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

[rflamenco]

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.