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.
Does incremental refresh work if you add non foldable steps after filterin Start/EndRanges?
Can you bypass that by loading the raw table with the filters and then using that as source in a new query?
I havent find the answer anywhere.
@PowerBITestingG , Not very clear, but you need make sure it foldable. For that make sure datatype is datetime and filter it very first steps. If you add any non foldable steps and then you add filter then it will not fold.
Another way is have query and try to pass Power query variable
A example of in Fabric and Data flow
Incremental Data Load(ETL) for Warehouse using Dataflow Gen 2, SQL Procedure, Data Pipeline: https://www.youtube.com/watch?v=mpFRnZBXsvQ&list=PLPaNVDMhUXGYU97pdqwoaociLdwyDRn39&index=1
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 |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |