Dataflows and query folding

Power Query
13

HI @ells,

I can only see multiple dataflow to help you in reducing your data size unless you are not reducing at source(which is out of scope per your scenario). Few question like–

  1. Have you set incremental refresh where you don’t need to refresh entire data?
  2. have you checked your query performance. Best way is to use PBI Desktop and try to optimize it. If possible share the M code with a sample data. You can read below post which I wrote yesterday that might help you …
  1. Best option is to split the dataflow with different source separately which will improve the refresh time for each dataflow.
  2. Also depends on the capacity you have been allowed in your organization so some solution will work for you and some will not, the only way is to experiment it in dev and test environment.

Thanks
Mukesh

1 Like