Power BI Only new lines

[Anonymous]

Hello,

New to Power BI i'm searching a solution for my problem of import only new line to my data. My dataset is directly connected to my SQL database and currently loads my data automatically on the 1st of the month.

My imported table for the moment has a column with a unique id as well as a date column (corresponding to the creation of the line). I have for the moment used the increment function by loading the last 30 days of data (last month) but I am looking instead to import based on the unique row id by only importing the data which is not present in my previous dataset.

Is there a solution ?

Regards,

Lilian / Talish

[lbendlin · Accepted solution]

No. Power BI has no memory. You should continue to use incremental refresh. You may enable the Data change column but be warned this will increase the size of your dataset by 100% as a shadow ("canary") copy will be maintained.

Hybrid datasets have been announced where you will be able to mix import mode partitions with a "today" direct query partition. This may or may not help you.