Forum Discussion
How to update a table without missing the older data?
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
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?