cancel
Showing results for 
Search instead for 
Did you mean: 

PowerQuery - Validating queries when saving is taking excessively long time

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

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

@MunroA7

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. 

altbra
Frequent Visitor

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 I

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

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

altbra
Frequent Visitor

Yep. Works super fast now.

AxiomaticNick
Frequent Visitor

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
Advocate V

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

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

Jase71ds
Helper I

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