Forum Discussion
Data from website for further statistical analysis
Hi,
I read a set of tables from a website and create a table report. Can can save this details inside PBI for further analysis? i dont have a database.
Eg:
Time 1.00 PM
| Product | Value |
| A | 100 |
Next refresh cycle data
Time 1.15PM
| Product | Value |
| A | 200 |
At 1:30 would like validate the data with perious ones.
Expected
| Time | Product | Value |
| 1:00 | A | 100 |
| 1:15 | A | 200 |
3 Replies
- amitchandak
Super User
Anonymous , There is DAX append method which has been mentioned in these blogs. See if that can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ 
v-lionel-msftCommunity Support
Hi Anonymous ,
If the data source will add a row each time it is updated, you can realize your idea by adding a refresh time column and using incremental refresh.
Use with incremental refresh.(Here I used manual refresh.)
But if your data is to modify an existing value, I am not sure whether you can add rows in Power BI.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
