Forum Discussion
Anonymous
3 years agoNot applicable
Question about the behavior of internal sub query processing in Power Query
Hi community I would have a question about the behavior of internal sub query processing in Power Query. Let's assume we have a query (A) that reads an external datat source, like : let ...
- 3 years ago
Unfortunately there isn't a built-in way to do this in PQ Desktop today. There are some workarounds, but they're not ideal.
One way to do this in the cloud world would be to use a dataflow. Load (A) as a computed entity, and then all the queries that reference it will get the same copy of (A). Is this an option for you?
Ehren
3 years agoMicrosoft Employee
Unfortunately there isn't a built-in way to do this in PQ Desktop today. There are some workarounds, but they're not ideal.
One way to do this in the cloud world would be to use a dataflow. Load (A) as a computed entity, and then all the queries that reference it will get the same copy of (A). Is this an option for you?