Data origin and update

[Anonymous]

Hello,

I am new to the platform. 

I have to access data exported in SQLite database format on a server.

Which is the best origin to use?

This data are updated on the same database almost each second so I will need to update them with refresh. At the end of the month, I would like to create an automatic update of the data, but on the correct month, without removing the old months. Is it possible? And how?

Thank you

[Anonymous]

and what about the correct origin to use?

[Anonymous]

Hi @Anonymous ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , If you do not have old month data in DB anymore, then you can check DAX append

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/