Updating existing data in Power BI from Visual Crossing automatically

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.

1 comment

Please sign in to leave a comment.