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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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

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

Emma_A
Frequent Visitor

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

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

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

HWinkelhorst
Regular Visitor

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. 

Anonymous
Not applicable

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

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

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

Anonymous
Not applicable

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

Same here, it's really frustrating