Forum Discussion
Refresh once a month and keep old data
Hello, I have a financial dataset that updates once a month. It’s on a SQL Server, and I execute a SQL query of all data everytime I refresh my powerbi. Like SELECT * FROM FinancialTable Where Date...
Hello Greg, thank you for the reply. This could be a solution, but my monthly data can’t be changed, so I would have to do this manual approach every month.
I’m thinking to make the monthly load using sql server agent by inserting the data on a new table, but I would like to have a solution just using Power bi.
I’m thinking to make the monthly load using sql server agent by inserting the data on a new table, but I would like to have a solution just using Power bi.
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi Guilhermealc,
Based on my research, you could refer to below blog.
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Regards,
Daniel He