Forum Discussion
Incremental refresh without date/time tag in table
- 4 years ago
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
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