0

Updating existing data in Power BI from Visual Crossing automatically

Tamera Johnson

May 11, 2023 21:02

None

Follow

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.

• Facebook
• Twitter
• LinkedIn

1 comment

• 
  Support Agent May 17, 2023 20:59 Official comment

  Thank you for your question. We are not aware of any direct way to append new data to a Power BI table. It is possible to merge or append two tables but this wouldn't provide an ongoing solution. 

  It may be easier to append to a table in SQL Server if that is an option for you. Appending data to an existing table is something that many of our clients do as part of their data loading process.

  Regards

  Visual Crossing Support