Forum Discussion
Refresh 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 new table in the query editor, to use in my reports as a combined datasource.
The old "database" is disabled for load on refresh, as that is supposed to be static data, but when I refresh the report, it at least looks like it would be loading the old data too, chunk by chunk of lines as it normally does.
Is that just how power bi visualizes the refresh or am I doing something wrong?
2 Replies
Hello 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!!
I was considering using incremental refresh, but won't it have to analyze all the old data before it loads whenever I refresh the report?
