selective refresh of the data

[brunoh]

Hello

I have a report which vizualizes production trends over 10 years (about 50000 rows in the main database)

My data are automatically refreshed daily in an excel file on a Sharepoint, and the PowerBi report gets data from this excel file.

It works ok, but refreshing 50000 rows in the excel file, then 50000 rows in PowerBi is quite lengthy, and useless, as all the historical data do not change.

I would like to split the data into a fixed historical table for which no refresh would be needed, and a recent table which would be refreshed daily, but would be much lighter.

For this I would need to tell PowerBI which table does need a refresh, and which does not need it.

Is there a way to make a selective refresh of data ?

Thank you 

[v-danhe-msft]

Hi @brunoh,

Based on my research, you could use the incremental refresh function to meet your requirements.

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

Regards,

Daniel He

[brunoh]

It is interesting, but I understand this feature is still in development, and only available with PowerBI Premium

The other solution proposed https://community.powerbi.com/t5/Desktop/selective-refresh-of-the-data/td-p/556768/jump-to/first-unr...

is simple and works well (although it obliges to split the data into 2 tables, then merge them in the query)

[rafaelmpsantos · Accepted solution]

Yes, in powerquery "Queries" right click in the "old" table, and uncheck "include in report refresh", like below.

if it solve please mark as solved and give me your positive feedback.

[brunoh]

Yes this solution fits my need. It will save considerable time in the data refresh.

Thanks