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.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.