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.
Hello,
How can I refresh the last specific days only in power bi desktop and keep all the data without having to use the incremental refresh and power bi services?
Best regards,
Muhammad Ezzat
@Anonymous Hi,
Implement incremental refresh on the local PBID doesn't work in theory.
The dataset of the PBID tabular model cannot be dynamically partitioned currently,
The only way is to use SSAS or Azure AS as the data source of Power BI and back-end model management because the data sets of SSAS and AAS can be dynamically partitioned, this means that the same data set can have two SQL statements that use different WHERE conditions, and they can be processed separately. But in Power BI Desktop, you can't do that.
Mark this post as solution if this helps, thanks!
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |