Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Well, you could do this with somewhat of a manual approach. In essense, 3 queries. First query gets everything <= some date. Second one gets everything > the same date. You Append the two queries together. You disable refresh on the first query. Now you have significantly reduced the amount of data that you are refreshing. You can later go in and adjust the dates in the queries and enable refresh on the first query. This will result in a large data load, then you disable the refresh on the query again.
It's manual, but it works without Premium.
Hi @Guilhermealc,
Based on my research, you could refer to below blog.
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |