Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm looking to a workaround to avoid long-lasting data refresh and I'm testing two scenarios and It seems working with DAX has a better result than query editor.
In the model there are two table
- table A (fresh data) of 10MB resh
- table B (historical data) 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
Why APPEND load so much data even if the biggest table is not refreshed?
Any other consideration observation?
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.