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 create...
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.

Anonymous's avatar
Anonymous
Not applicable
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.