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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How Power BI update the record!

Confused about how PBI update the record in scheduled refresh.I read in article that it refresh only updates and does not refresh whole data again (and it's making sense to me as in case of data in GB ideally it should not refresh whole data.) but again another thing clicked in mind if it refresh only updates in Powerbi.com then why we have a new feature of Incrementle refresh.

 

Please clarify this issue!

 

 

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi,@pundiv01

    You have a misconception about scheduled refresh.

    When you refresh data, you are updating the data in the dataset that is stored in Power BI from your data source. This refresh is a full refresh and not incremental.

reference:https://docs.microsoft.com/en-us/power-bi/refresh-data

For example:

We import a table with three columns, If data in column1 updated, when it refreshed in power bi, it will refresh

all the data in three columns not just only refresh cloumn1.

 

Incremental refresh enables very large datasets in the Power BI Premium service with the following benefits:

  • Refreshes are faster. Only data that has changed needs to be refreshed. For example, refresh only the last 5 days of a 10-year dataset.

  • Refreshes are more reliable. For example, it is not necessary to maintain long-running connections to volatile source systems.

  • Resource consumption is reduced. Less data to refresh reduces overall consumption of memory and other resources.

Reference:https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

For example:

Assume that we have a data source include 5 years data, if we don't use Incremental refresh, it will check and refresh all the data,this needs high performance requirements and lots of time.

but if we use Incremental refresh, we can define that it only check and refresh last 10 days data.

 

Regards,

Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi,@pundiv01

    You have a misconception about scheduled refresh.

    When you refresh data, you are updating the data in the dataset that is stored in Power BI from your data source. This refresh is a full refresh and not incremental.

reference:https://docs.microsoft.com/en-us/power-bi/refresh-data

For example:

We import a table with three columns, If data in column1 updated, when it refreshed in power bi, it will refresh

all the data in three columns not just only refresh cloumn1.

 

Incremental refresh enables very large datasets in the Power BI Premium service with the following benefits:

  • Refreshes are faster. Only data that has changed needs to be refreshed. For example, refresh only the last 5 days of a 10-year dataset.

  • Refreshes are more reliable. For example, it is not necessary to maintain long-running connections to volatile source systems.

  • Resource consumption is reduced. Less data to refresh reduces overall consumption of memory and other resources.

Reference:https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

For example:

Assume that we have a data source include 5 years data, if we don't use Incremental refresh, it will check and refresh all the data,this needs high performance requirements and lots of time.

but if we use Incremental refresh, we can define that it only check and refresh last 10 days data.

 

Regards,

Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Great help!!Really thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.