Forum Discussion
Harry_Tran
Helper III
Helper IIIHow to capture monthly snapshot data
Hi everyone, I have a report which connects to SQL Server and my data is updated daily. I need to refresh the report monthly on the 2nd day of the month. the logic for the report is: Report date ...
V-lianl-msft
Community Support
Community SupportHi Harry_Tran ,
Based on your description, configuring incremental refresh for the dataset can meet your needs. Please refer to:
https://powerbiexperience.com/en/how-to-correctly-use-incremental-refresh-and-not-fall-into-traps/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.