Incremental refresh without date/time tag in table

[M0skus]

Hi, 

I'll preface by saying I've just started learning Power BI. 

So I'm trying to figure out if I can keep historical data when refreshing a table to visualize change over time. 

I have a simple table, listing different activities that are overdue at any given time. Meaning everytime I refresh, I get the status as of right now.

Maybe instead of getting in to the "how", I'll start with if its possible at all:

Seeing as the data doesnt have date/time tags, can incremental refresh be used to keep history, and tag data with refresh date?

[ribisht17 · Accepted solution]

@M0skus 

Supported data sources

Incremental refresh and real-time data works best for structured, relational data sources, like SQL Database and Azure Synapse, but can also work for other data sources. In any case, your data source must support the following:

Date column - The table must contain a date column of date/time or integer data type. The RangeStart and RangeEnd parameters (which must be date/time data type) filter table data based on the date column. For date columns of integer surrogate keys in the form of yyyymmdd, you can create a function that converts the date/time value in the RangeStart and RangeEnd parameters to match the integer surrogate keys of the date column. To learn more, see Configure incremental refresh - Convert DateTime to integer.

Find more info > Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

Regards,

Ritesh

Ritesh

Mark my post as a solution if it helped you so that it can help others as well| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin