Forum Discussion
How to update a table without missing the older data?
Hello!
Let's see if I'm able to make me understand...
I need to connect power BI to a web source which is updated everyday with the daily value.
The point is that the web just shows the data of the last 30 days, therefore when I refresh my power BI in order to update the table, I have certainly the date of the last 30 days but unfortunately I miss the data of the older dates (since day -31)
How can I do to keep all the older data when I refresh?
In other words, I would like my table to be updated every day, adding the new value and mainteining all the existing values.
Is it possible?
Many thanks for your help! 🙂
Hi Vinzitc ,
Power BI is a business analytics solution developed by Microsoft. It allows you to visualize your data and share insights across your organization, or embed them in your app or website. You can connect to different data sources, like web, excel and sql etct. However, it can't store the old data if that data not exist in the data source.
If you want to show old data in Power BI, you would need to set up a data source that stores the older data from your web source and then use Power BI to connect to that data source. This could be a database or a data warehouse that supports incremental data loading. This way, each time you refresh your Power BI report, it would pull in the new data from the web source and add it to the existing data in your database or data warehouse. Then, Power BI would connect to this database or data warehouse to get the full set of historical data.
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Best Regards
2 Replies
Hi Vinzitc ,
Power BI is a business analytics solution developed by Microsoft. It allows you to visualize your data and share insights across your organization, or embed them in your app or website. You can connect to different data sources, like web, excel and sql etct. However, it can't store the old data if that data not exist in the data source.
If you want to show old data in Power BI, you would need to set up a data source that stores the older data from your web source and then use Power BI to connect to that data source. This could be a database or a data warehouse that supports incremental data loading. This way, each time you refresh your Power BI report, it would pull in the new data from the web source and add it to the existing data in your database or data warehouse. Then, Power BI would connect to this database or data warehouse to get the full set of historical data.
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Best Regards
Thank you for your help.
Do you (or anyone) know if I can use Excel or other tool can extract data automatically from a web and going increasing the database without missing data?
If yes: How can I do?If not: Do you know other tool to do it?
