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: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

michaelsh

Dataflows very very slow Validating Queries

Submitted by Kudo Kingpin on ‎04-14-2021 04:38 AM

Simple SQL query that runs 7 seconds in SQL takes 19 minutes(!) to validate in Dataflows

19 minutes!!!???
Not just one query.

I've tried SQL Server and PostgreSQL - the time it takes to Validate is just crazy.

What is going on?

Please help

Status: New
See more ideas labeled with:
46 Comments (46 New)
Comments
rjgillin13
Frequent Visitor
‎08-30-2021 03:43 PM

Agreed...This is terrible. I have spent over a week trying to set up a dataflow with painfully long "validating queries" wait times. This is something that needs immediate attention. For something that holds so much promise, this experience is almost enough for me to look elsewhere for a BI solution. 

RGV
Regular Visitor
‎09-25-2021 09:41 AM

Experiencing the same issue here. Just changed a direction of a relationship and its more than 20mins and its still validating. This is a productivity killer..

michaelsh
Kudo Kingpin
Kudo Kingpin
‎11-06-2021 03:02 AM

Still hapenning. now in MySQL

michaelsh
Kudo Kingpin
Kudo Kingpin
‎11-22-2021 03:22 PM

Still Sloooooowwwww. Sharepoint folder, no gateway.

The whole dataflow itself refreshes in 7 minutes, but any change to queries I have to wait for "Validating queries" for more than 24 minutes!!!!

Please, mercy!!!

AdamSabourin
Frequent Visitor
‎11-29-2021 11:26 AM

I'm suffering from this as well!! Dataflows are borderline inoperative at this point due to the spinning wheel of validation death!!!

meggermann
Regular Visitor
‎11-30-2021 06:34 AM

Another +1 on this. Validating a dataflow that reads few excel files from Sharepoint online w/ maybe 700 rows total has so far taken over 45 minutes. It was always on the slow side - but this is really beyond slow. As otheres have said - not usable.

 

vhecgn
New Member
‎12-12-2021 03:17 AM

Can confirm this behaviour, in our case on a premium capacity. Just validating a dataflow often takes many minutes. Quite annoying. 

jopires0
New Member
‎01-06-2022 07:18 PM

I'm experiencing terrible performance to save changes to a Dataflow. The "Validating Queries" process is taking forever and has already aborted twice.

 

I do not see any comment from Microsoft on this issue. Does anybody know what is going on with Dataflow saving performance?  Thanks

Anonymous
Not applicable
‎01-13-2022 09:16 AM

100% agree on this, very frustating, especially when PBI is the only "analytics" tool company rely on, very frustating. 

twilkins0n
Regular Visitor
‎02-03-2022 10:47 AM

Just want to chime in, I'm waiting several hours for validation of dataflows that take only a few minutes to refresh.  Very difficult to manage when any change involves such a monster time sink.

 

What's strange is that if I copy the queries into a Power BI desktop transform, they process and populate quickly without any of this nightmare black hole...so I know it's avoidable.

 

It is certainly disappointing that Microsoft does not care enough to even comment on such a huge waste of our time.  This is a tremendous downside for using dataflows.

Idea Statuses