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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

uberdube

PowerQuery - Validating queries when saving is taking excessively long time

Submitted by Advocate IV on ‎12-03-2019 12:09 AM

I'm struggling to be able to work efficiently with Dataflows as I am experiencing excessive times to 'validate' queries after pressing the 'Save & Close' button. For entities with even a minimal amount of transformation (eg. simply changing some column data types) I've experienced wait times of over 3 hours to simply save the query to exit out back to the main entity menu/view. Should things be taking this long for an output schema validation process, regardless of the size of the underlying table data? Is this an issue being experienced by others as well?

This is making it simply impossible for me to work with the Dataflows product in this way.

 

2019-12-03_16-00-57.png

Status: New
See more ideas labeled with:
93 Comments (93 New)
Comments
Gulan70
Frequent Visitor
‎05-17-2021 11:53 AM

It is pure performance.  This afternoon, I cancelled a validation after more than 5 hours.  Now in the evening: 4 minutes for the same content.

bdarbo78
Advocate II
Advocate II
‎05-17-2021 12:49 PM

@Anonymous

It looks like I was just lucky then, and too eager to boast about what I thought was a solution. I must admit that I did not perform extensive tests. Just tried it. I hope that MS will soon come with a solution to ease the development of dataflows. 

Anonymous
Not applicable
‎05-19-2021 12:23 AM

Hi colleagues,

 

This is what I got from the Support Team. 

 

Greeting for the day!!!!

With regards to your issue we checked with our internal team and they confirmed its a known issue “Slow Dataflows Editing and Validation”.

As per the Internal team update they created a bug ticket for this issue and it will get fixed by today i.e., 18th May EOD.

Please feel free to reach out us in case you have any concern regarding this issue and we will be happy to assist you.

I look forward to hearing from you soon!

Cheers & Stay Safe and Healthy!

image002.jpg

ryan0585
Advocate II
Advocate II
‎05-19-2021 07:14 AM

That's great news, thank for sharing!  A little sad that this is a couple hours/days correction on their end but it took this long and this much frustration from folks to get it prioritized.

Gulan70
Frequent Visitor
‎05-19-2021 07:16 AM

It's looking much better indeed. Hope it lasts.

Anonymous
Not applicable
‎05-20-2021 12:46 AM

Yep. Works super fast now.

Anonymous
Not applicable
‎05-20-2021 06:59 AM

I also was getting results faster than I have been in the past couple weeks.  I'm cautiously optomistic this has been addressed and at least fixed to some degree.

michaelsh
Kudo Kingpin
Kudo Kingpin
‎05-21-2021 01:52 AM

Yes, it is working faster.

Microsoft, thak you for fixing.

Please, update us on these issues.

This community is the place for keeping us updated.

Thanks

bdarbo78
Advocate II
Advocate II
‎06-15-2021 09:14 AM

From my perspective (located in France), the issue is back and has not been fixed. 

Jase71ds
Advocate I
Advocate I
‎06-16-2021 06:22 AM

@bdarbo78 

In Houston. Yesterday was horrible, but I was using FireFox browser.

Today is slow but manageable - using Edge.

Not sure if switching browsers was key - I've never had issues before in FF, and I much prefer it. But I'll keep using Edge and see how things go from here. At least I can get work done - albeit, slowly.

Idea Statuses