Forum Discussion

Sparsh98's avatar
Sparsh98
Regular Visitor
2 years ago
Solved

Daily Append Datasets Refresh Strategy

HI PowerBI Community ,  I am new to PowerBI and need some help in a particular use case .  One of my client's input comes from a SQL Database and the refresh process set is append .  So I have a q...
Dataflow
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Sparsh98 ,

    Yes, your data source must have a date/time column if you want to configure incremental refresh.

     

     

    Best regards,
    Community Support Team_Binbin Yu
    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 Sparsh98 ,

Please try to configure incremental refresh, Power BI will according to your create policy to refresh the data.

There are some requirements for set incremental refresh:

1. Incremental refresh is supported for Power BI Premium, Premium per user, Power BI Pro, and Power BI Embedded models.

2. Your storage mode is Import

3. Data source have date/time field

4. Data source support query folding

 

For more details, you could read related document: Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn , Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Sparsh98's avatar
    Sparsh98
    Regular Visitor
    2 years ago

    Hi Anonymous, so to be more clear does it means that I need to have a date/time column in my data source compulsorily ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Sparsh98 ,

      Yes, your data source must have a date/time column if you want to configure incremental refresh.

       

       

      Best regards,
      Community Support Team_Binbin Yu
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.