Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Incremental refresh handle deletes not working

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

 

 

Need Help

3 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      "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.