Forum Discussion
Data origin and update
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
3 Replies
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/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 _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
