Forum Discussion

Guilhermealc's avatar
Guilhermealc
Regular Visitor
7 years ago

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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Well, you could do this with somewhat of a manual approach. In essense, 3 queries. First query gets everything <= some date. Second one gets everything > the same date. You Append the two queries together. You disable refresh on the first query. Now you have significantly reduced the amount of data that you are refreshing. You can later go in and adjust the dates in the queries and enable refresh on the first query. This will result in a large data load, then you disable the refresh on the query again.

 

It's manual, but it works without Premium.

Guilhermealc's avatar
Guilhermealc
Regular Visitor
7 years ago
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.