Forum Discussion

DennisSchlein's avatar
DennisSchlein
Helper III
2 years ago
Solved

Incremental refresh designer - error

Hi  I'm trying to setup incremental refresh in a report. This is connected to a azure sql. let startDate = DateKey(RangeStart), endDate = DateKey(RangeEnd), Source = OleDb.DataSource("p...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi DennisSchlein ,

    It looks as if the cause of your refresh error is happening on the data type 'datetime2':

    Please check the data types of the columns in your database table. Ensure that the data types of the columns match the data types of the parameters used in the query.
    Both the parameters data type and the filtered data column must be Date/Time data type and the format must be the same.

    You can learn more about Incremental refresh and maybe you can find solution here:
    Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn

    Best Regards,

    Dino Tao

    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 DennisSchlein ,

It looks as if the cause of your refresh error is happening on the data type 'datetime2':

Please check the data types of the columns in your database table. Ensure that the data types of the columns match the data types of the parameters used in the query.
Both the parameters data type and the filtered data column must be Date/Time data type and the format must be the same.

You can learn more about Incremental refresh and maybe you can find solution here:
Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn

Best Regards,

Dino Tao

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