Incremental Refresh

[Anonymous]

Hello Team,

Hope you are having a great day, I have a small issue or a concern hope you will be able to resolve it.

I have my data source as MS SQL, and the native query working as well I created the parameters too but still after Selecting the Incremental refresh option, I am getting an error before you can set up incremental refresh on this table you need to set up parameters because of it I am unable to enable the incremental refresh option in Power BI and I have Pro Licences

Could you please help me out with it?

Best Regards,

Prakash

[Anonymous · Accepted solution]

Hi @Anonymous ,

If I understand correctly, the issue is that you encountered the error when selecting the incremental refresh. Please try the following methods and check if they can solve your problem:

1.Confirm that the parameters RangeStart and RangeEnd are correctly set up.

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

2.The parameters should be of the Date/Time data type and formatted correctly to match the table column.

3.Make sure that the data sources supports query folding.

Query folding - Power Query | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Hi @Anonymous 

Did you follow instructions on how to create parameters and incremental refresh?

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview