Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am using incremental refresh for one of the tables in my model since that table is large and takes over 5 hours to refresh.
My concern with using incremental refresh is that now I can barely make any changes to the data, such as changes to the other tables in PowerQuery, editing measures, or adding calculated columns. This is important to me since I am continously updating and improving the report, displaying new and different information.
I understand I can store the incrementally refreshed table in one PBIX file and the report itself in another PBIX file so that I can still make changes to the data, but then the incrementally refreshed table needs to use a direct query connection which is too slow for me since there are nearly 100 milion rows in that table.
How can I go about this? Can I make all these changes in Tabular Editor? Thank you so much!
Hi @meirlicht,
I think the incremental refresh should not be suitable for this scenario.
AFAIK, current power bi does not include any historical data feature. If your old records will be updated/replaced when new records added, I'd like to suggest you export these daily changed records to a new table and add a custom field to remark the operation timestamps.(change the edit operation to add new records with new timestamps)
After these steps, you can simply getting data from the new table to analysis the historical data changes.
Regards,
Xiaoxin Sheng
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
72 | |
68 | |
41 | |
35 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
42 |