Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I've implemented Incremental refresh for my PBI Premium dataset with the folowing settings.
Parameters (RangeStart and RangeEnd) on the 'DataLoaded' column.
Detect data changes on VersionUpdateDate
And a filter on CurrentVersion = 1 to handle deletes.
Preview Query Editor
Filter to handle deletes/current version
But when the current version is changed on a previous period/partition power bi doesn't update the old data.
Probably because of Power BI sends a query to the database with the following where-clause 'CurrentVersion = 1' and doesn't find the updated row in the returning table.
Source table:
Partitions:
Does any of you have a solution for this problem?
Br
Nik
Hi @Anonymous
Yes, you are right. When you add a filter on CurrentVersion = 1 in Power Query Editor, only rows whose CurrentVersion value is 1 will be imported into Power BI.
You could remove the filter CurrentVersion = 1 in Power Query Editor and apply the changes, then rows with all version values in the date range will be imported into the model. (Or filter rows with version values currently used or to be used in the future.)
As an alternative, you could add a filter or a slicer in the report to select which version data to see in the report. At last, republish the report to Service to make incremental refresh work.
Reference that may help:
Incremental refresh in Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
"You could remove the filter CurrentVersion = 1 in Power Query Editor and apply the changes, then rows with all version values in the date range will be imported into the model. (Or filter rows with version values currently used or to be used in the future.)"
Is there a way to filter the dataset after the data has ben loaded in to the dataset? So all of my reports that has this dataset as source won't show the versions that is not the currentversion?
I have tested using RLS and applied CurrentVersion = 1 but then all of the data shows in my Pagniated Reports.
@Anonymous sorry for the late reply.
If it is Power BI report, you could use filters in the report to decide which data range to show.
If it is Paginated report, you could use parameters to narrow the scope of data. This video may be helpful: Power BI Paginated Reports: Data source, Dataset and parameters - YouTube
Best Regards,
Jing
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
26 | |
24 | |
19 | |
16 |
User | Count |
---|---|
49 | |
38 | |
24 | |
20 | |
20 |