Forum Discussion
selective refresh of the data
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
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.
4 Replies
- rafaelmpsantos
Responsive Resident
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.
v-danhe-msftMicrosoft Employee
Hi Anonymous,
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
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-unread-message
is simple and works well (although it obliges to split the data into 2 tables, then merge them in the query)