Forum Discussion
Append Query with Large, Static Data to Query with Small Changing Data
I am experiencing performance issues with appending queries with OData sources. Assumptions / Scenario: I have 4 OData feeds that show sales data I would like to join. Queries A and B are hist...
I’m the same situation:
- table A of 10MB
- table B of 100MB (“enable load”turned off)
Scenario1)
Using APPEND in query editor. Every refresh take a lot of time and Power BI load 100MB
Scenario2)
Using DAX function UNION to create an additional table. Refresh is fast and load only 10MB of data
Any suggestion?