Dataflow Timeout?

[Anonymous]

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?   

[v-frfei-msft]

Hi @Anonymous ,

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.