Forum Discussion

gvlado's avatar
gvlado
Icon for Advocate III rankAdvocate III
1 year ago
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...
Need Help
  • gvlado's avatar
    gvlado
    1 year ago

    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. 

Ajithkumar_P_05's avatar
Ajithkumar_P_05
Icon for Helper I rankHelper I
1 year ago

 

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.

 

 

gvlado's avatar
gvlado
Icon for Advocate III rankAdvocate III
1 year ago

It doesnt work - that is why I am asking for help