Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
We have a data table with lots of calculated columns for a long period of time.
The thing is when we add new rows to this table, it does the calculating for the columns from the start.
For example, our data is between 1st Jan 2019 and 1st March 2019. When we add the rows from 2nd of March, power bi calculates the columns again from 1st Jan and this takes a very very long time (around 5 hrs).
What we need is a way for power bi to stop calculating like this and only calculate the new rows (after 2nd of March in this example).
Is there a way to do this?
Thank you,
Look here, but i haven't touc this option yet
https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/
User | Count |
---|---|
84 | |
79 | |
63 | |
62 | |
51 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |