Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PeopleAnalytics
Regular Visitor

Partial Refresh

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,

1 REPLY 1
az38
Community Champion
Community Champion

Hi @PeopleAnalytics 

 

Look here, but i haven't touc this option yet

https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/

 


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.