Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |