Forum Discussion
zahlenschubser
Helper IV
Helper IVRefresh and disabled queries
I have some rather large tables in my source, so I use one filtered by older dates as a database and a smaller one filtered by newer dates as the "current" dataset and then append both together as a ...
Kishore_KVN
Solution Sage
Solution SageHello zahlenschubser ,
As you are appending and creating new query or table it always refresh old data as well. So it is not suggested to do that way.
Best way to handle this situation is by applying Incremental Refresh. Please look at below link to know more about incremental refresh:
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
zahlenschubserHelper IV
Helper IVI was considering using incremental refresh, but won't it have to analyze all the old data before it loads whenever I refresh the report?