Hi--I have downloaded weather history back to 2014 for 6 cities and uploaded it into Power BI.
Now I need a way to automatically add new data. Is there a way I can add new data without having to re-download the existing data?
I am using an api using csv for the last 1 day which downloads the previous day and the current day's data. I want to append that to the current data table I have--data for this table is coming form an SQL Server.
Any suggestions? I tried appending the data, but the new data wouldn't append to the existing table.