Hi everyone,
Im currently building a report in Power BI Desktop (PRO license) which is pulling at least data from previous 12 months. Source is an Odata connection. And I want to avoid refreshing every day 12 months of data, takes too long and get timeouts all the time.
I'm building my Query A, which pulls data (merged) from query B, which at same time pulls data (merged) form Query C. So, Query A = B + C.
Furthermore, to avoid any firewall problem with queries referencing other queries, I've set up a solution following Ken Puls solution.
In other words:
- Query C as it is, with incremental refresh. "Enable load" disabled.
- Query B splitted:
> Query B1 is pulling data from source (oData), with incremental refresh. "Enable load" disabled.
> Query B2 is pulling data from Query B1 + merged with Query C. No incremental refresh. "Enable load" disabled.
- Query A splitted:
> Query A1 is pulling data from source (oData), with incremental refresh. "Enable load" disabled.
> Query A2 (the table I need to build report from) is pulling data from Query A1 + Query B2. No incremental refresh. "Enable load" enabled.
What do you think about this setup? Makes sense? Should i turn incremental refresh for all queries? I'm still getting long loading times.
Thank you so much,
