cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thosepants New Member
New Member

How to refresh only yesterday's data?

Hi,

 

Everyday we append a master data file to include data from yesterday.

We then refresh this master file in PowerBI to run our daily reports on the data.

These reports require all the data in the master file (they require yesterday's data and all previous data)

 

The problem is that the master file is becoming quite large.

When we do a "refresh" in PowerBI, PowerBI insists on reloading the entire master file rather than only loading the new rows of data from yesterday.

Is there a way to make PowerBI only load in the new data and not the entire file?

 

In our case the master file is a table in DB2, but we have the same problem if we append an Excel file and use that as the master file.

 

Any help would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to refresh only yesterday's data?

Hi @thosepants ,

 

You can configure incremental refresh, Incremental refresh can significantly reduce data refresh duration and only refresh data that has changed , especially for large model tables.

 

Incremental refresh is supported only for workspaces on Premium capacities, and Incremental refresh policies are defined in Power BI Desktop and applied when published to the Power BI service.

 

You can learn more: Incremental refresh in Power BI Premium .

 

Best Regards,

Amy

 

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
Community Support Team
Community Support Team

Re: How to refresh only yesterday's data?

Hi @thosepants ,

 

You can configure incremental refresh, Incremental refresh can significantly reduce data refresh duration and only refresh data that has changed , especially for large model tables.

 

Incremental refresh is supported only for workspaces on Premium capacities, and Incremental refresh policies are defined in Power BI Desktop and applied when published to the Power BI service.

 

You can learn more: Incremental refresh in Power BI Premium .

 

Best Regards,

Amy

 

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

Community Support Team
Community Support Team

Re: How to refresh only yesterday's data?

Hi  @thosepants ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors