Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Jeffreyalbright

Dataflows

Submitted by on ‎03-25-2022 05:32 AM

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.

Status: Accepted

Existing ICM for similar issue(ICM 297756751). It should be a new known issue that dataflow refresh taking long times that usual to complete. Employee engages this issue as well.

See more ideas labeled with:
41 Comments (41 New)
Comments
jmlove0923
Frequent Visitor
‎03-25-2022 06:14 AM

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
Regular Visitor
‎03-25-2022 06:43 AM

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
Advocate I
Advocate I
‎03-25-2022 06:50 AM

I put in a ticket...

edhans
Community Champion
Community Champion
‎03-25-2022 07:52 AM

Yup. Down for me too.

ttrotter785
Regular Visitor
‎03-25-2022 07:59 AM

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

ccconley
Frequent Visitor
‎03-25-2022 08:17 AM

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
Community Champion
Community Champion
‎03-25-2022 10:05 AM

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

Jeffreyalbright
Regular Visitor
‎03-25-2022 10:31 AM

Still not refreshing on my end.. 

 

**We have submitted a ticket for the issue.

derricklo
Regular Visitor
‎03-25-2022 12:03 PM

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
Advocate I
Advocate I
‎03-25-2022 02:33 PM

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. 

Idea Statuses