Forum Discussion
include in report refresh - understanding
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.
Hi gvlado ,
We can achieve this by configuring incremental refresh. For that, you don't have to separately pull data 1, 2, 3 query. All together you can pull the data and setup incremental refresh for last 1 week, Month, Quarter or Year as per your requirement. Please check the link below.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure
Please let me know if you have further queries on it. Happy to help out.
Appreciate a kudo if my post has helped you in anyway.🙂
Thanks,
Pallavi
My files are in diferent folders on SharePoint. Not in one folder or SQL or some other easy folding (nice and easy for incremental refresh). Do you have kind of example for a solution "not to load already loaded data from SharePoint folders?