Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Dataflow Timeout?

I am trying to create a dataflow within a workspace (not in the desktop app), but I keep getting a time out error.  I have a rather large table I need to get sales for the last 12 months, but keep getting a time our error on a left join to the customers table. 


I don't want to waste resources, but I can't figure out a way to lessen the burden and a select statement is not an option.  Any ideas?   

Community Support
Community Support

Re: Dataflow Timeout?

Hi @SWard7408 ,


If your dataflow isn’t in a Premium capacity workspace, you can still reference a single query or combine two or more queries as long as the transformations aren’t defined as in-storage transformations. Such references are considered standard entities. To do so, turn off the Enable load option for the referenced queries to prevent the data from being materialized and from being ingested into storage. From there, you can reference those Enable load = false queries, and set Enable load to On only for the resulted queries that you want to materialize.


Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors