Forum Discussion
Building weather histotic data
Hello,
I have a table with an API to a weather service. My API gets the daily forecast for the current day + the condition at the time the table is updated. I update it twice a day to build a report for the AM shift and one for the PM work shift. Each time I refresh it, the table contains just one row with the data from the API (perfectly normal).
What I would like to do, is to add the row of data I receive from the API to another table so I can build an history so the reports from the previous days have the weather data. Is this possible in Power BI ?
Hi Gilgam81 ,
Agree with johnt75. You can create a Power Automate flow to export visual data automatically. Below is the reference:
Power BI export to excel and csv with Power Automate
By exporting data to a fixed location, you can create reports on historical data based on this data source.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
johnt75Super User
No, this isn't possible in Power BI. You would need to use Power Apps or some other technology to grab the data and either add new rows to a spreadsheet or store it in a database somewhere. Then Power BI can get the data from wherever you stored it and you would have historic data.
Hi Gilgam81 ,
Agree with johnt75. You can create a Power Automate flow to export visual data automatically. Below is the reference:
Power BI export to excel and csv with Power Automate
By exporting data to a fixed location, you can create reports on historical data based on this data source.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Stephen !
