I am experiencing performance issues with appending queries with OData sources.
Assumptions / Scenario:
I am under the impression I need to do this append procedure in order to make the data appear, on the visualizations, as if it's all coming from one data source. I am expecting, that with "Enable Load" turned off on the large queries, the load of the appended Query D would be fast. However, it would appear that all of the data is being refreshed from all of the Queries, since the overall refresh of the workspace takes as long as manually refreshing Queries A and B (the large ones).
Does anyone have any strategies we could use here? If there is a way to not append these queries, but make them all appear as if they're coming from the same datasource, I'd be interested in that solution as well. Currently, if I were to chart the Sales from the 4 separate queries, they'd always look distinct from one another; something we want to avoid.
Thanks for any insight here!
You may check if the following article helps.
Thanks for the suggestion! I did toggle that option but it isn't making an impact. There aren't "many" queries in the workspace, some just seem like they're "large" datasets for OData to deliver (65 MB); that doesn't seem to large to me and would suspect downloading that OData wouldn't take but a few seconds with our connection speed.
I’m the same situation:
- table A of 10MB
- table B of 100MB (“enable load”turned off)
Using APPEND in query editor. Every refresh take a lot of time and Power BI load 100MB
Using DAX function UNION to create an additional table. Refresh is fast and load only 10MB of data