Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Incremental Refresh

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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies