Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
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
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)
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.
Yes this solution fits my need. It will save considerable time in the data refresh.
Thanks
User | Count |
---|---|
121 | |
69 | |
67 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |