cancel
Showing results for 
Search instead for 
Did you mean: 

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
Comments
v-chuncz-msft
Community Support

@michaelsh 

 

That seems to work fine for me. You may take a look at Dataflows best practices.

michaelsh
Helper V

@v-chuncz-msft 

Please see this:

https://youtu.be/5fHsRwEM7SY?t=621

But please, please, see it through, read the comments and please, listen to the users, not just me:

The Validation step TAKES FOREVER! It just SUCKS!

The users are wasting TONS of time for this.

This is an AWEFUL experience!

Please fix

Thank you!

TMOCostanzo
Helper V

If I could thumbs up this I would a million times over. It makes no sense why it takes so long to 'validate.' 

 

I've had multiple DF's take 20-30 minutes to validate and yet the refresh takes 4 minutes. Makes no sense to me at all. It would be nice if there was some intelligence behind it. I've even had it take that 30 minutes to validate the data flow when the only thing I did was delete a table. Since there is logic in place that prevents me from deleting a query in use, the delete should be clean, why does it require a full rebuild of everything again?

michaelsh
Helper V
altbra
Frequent Visitor

Same issue.

 

I found out that Validating and Editing work super fast outside of working hours.

 

Submitted a ticket to Microsoft.

Gulan70
Frequent Visitor

It's pure performance issue on MS side. Very frustrating: sometimes more than 2 hours for a few changes!
It is my opinion also that after hours or in the weekends you have sometimes more luck.
But this unprofessional slow.