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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
altbra
Frequent Visitor
‎05-12-2021 06:34 AM

The worst thing is the silence from the Power BI Team.😠

Emma_A
Frequent Visitor
‎05-12-2021 07:48 AM

I cannot do anything to my dataflows, either updating, disabling a query(!!) or creating a new dataflow, as it takes forever to validate and then falls over saying an error occurred. On top of that the dataflows aren't even refreshing unless at the crack of dawn!

Anonymous
Not applicable
‎05-17-2021 06:34 AM

I tried to validate a dataflow today based on Dataverse.  I started it at 11am and it's 2:30pm now and it's still showing the yellow circle of doom with the validation message.  This is after the apparent fix for making sure dataflows refresh.  Can't do anything with them at the moment.  None of them will save or validate.

michaelsh
Kudo Kingpin
Kudo Kingpin
‎05-17-2021 07:55 AM

Microsoft, please talk to us. Tell us what's going on

HWinkelhorst
Regular Visitor
‎05-18-2021 05:57 AM

Same problem I let the validation run over night to see if it would complete at all. The dataflows are a complete unworkable mess ever since the 28th of April. 

jhlees
Regular Visitor
‎05-18-2021 06:17 AM

This seems to me to be region-related - i.e. which MS datacentre/datacenter we are using.

Dataflow on my client's tenant (Pro) - Europe North - currently unworkable (I gave up waiting for validation after 90 minutes)

Same dataflow created on my own MS tenant (Pro) - UK South - validation takes circa 20 seconds.

HWinkelhorst
Regular Visitor
‎05-18-2021 06:43 AM

All my client's tennants are on West Europe (Netherlands), seems to be a little better today but far from what it used to be a few weeks ago. In one instance it took 28 minutes to read a table with 3 columns and 6 lines. What is going on, this should not be possible in 2021

HWinkelhorst
Regular Visitor
‎05-19-2021 01:05 AM

Today things are running quite normal again for all customers let's hope it stays stable this time.

Anonymous
Not applicable
‎06-18-2021 03:17 AM

I think it is absolutely unacceptable that even after minor changes the whole dataflow needs to be completely rebuilt and validated. Please, add some intelligence to the validation process!

Yousra
Advocate I
Advocate I
‎06-22-2021 03:45 AM

Same here, it's really frustrating

Idea Statuses