Data snapshot using Power BI Incremental refresh.

[BIMJ]

I know there is no default option to take data snaphots in Power BI. My requirement is to store/append the data on a Daily or Weekly basis on Current date (from SQL) and then compare the data on daily/weekly basis.

I used incrimental refresh with a tweak - however it is not working. It replaces the records. Below are the steps I followed. Let me know if anyone knows how to make it work.

I made a view of the SQL in Teradata with Current date time as a column and used this view inside PBI. Created RangeStart and RangeEnd and finally configured the incrimental refresh. I scheduled to run daily. Ideally, when my query runs in teradata, each time the Current date time is different and PBI should think they are new set of rows even if other columns are same. So basically I am expecting a set of rows with new Current date time plus the old records with previous Current date time. Isn't it supposed to work like that? Please let me know.

Here is the sample of SQL used for the view (ignore the syntax)

select

product,

Sales,

current_date_time as SQL_DATE_TIME

from sales

[otravers · Accepted solution]

You can create snapshots with Power BI using dataflows with the Bring Your Own Storage option:

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-azure-data-lake-storag...