Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 query with me which needs to run daily to get particular day's result . Now my problem is how can I append my daily query results to my historical data , in order to do visualizations on latest data available.
I have a csv file having historic data with me.
Schedule Refresh works well when the refresh process is replace but how shall i perform it in case of append
I also read about Incremental Refresh but I observed that there should be a date column necessary in data which can be used for start and end date .
Solved! Go to Solution.
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.
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...
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.
Hi @Anonymous, so to be more clear does it means that I need to have a date/time column in my data source compulsorily ?
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
33 | |
25 | |
23 | |
21 |
User | Count |
---|---|
57 | |
40 | |
26 | |
24 | |
22 |