Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Dataflows very very slow Validating Queries

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
Frequent Visitor

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. 

Regular Visitor

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

Kudo Kingpin

Still hapenning. now in MySQL

Kudo Kingpin

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

Frequent Visitor

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

Regular Visitor

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.


New Member

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

New Member

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

Not applicable

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

Regular Visitor

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