Forum Discussion
Solved
include in report refresh - understanding
Dear Community I have few queries: Data 2022, Data 2023, Data 2024 This data are in SharePoint separated subfolders (Data 2022 then Data 2023 then Data 2024) Then I combine it as append all 3 (Dat...
I found solution
The problem is if we want to disable "include in report refresh" then we have to use "union" in DAX not append in Power query. It is because if we use Append then there is depedant query and include in report refresh doesn't work.
Import 2022 and 2023 data locally into Power BI as static tables (disable refresh) then Set up incremental refresh for 2024 data in Power BI Service to handle daily updates efficiently.
It doesnt work - that is why I am asking for help