Data from website for further statistical analysis

[Anonymous]

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

[v-lionel-msft]

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 Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

No .only one row will be there in output.. I want to cache previous value

[amitchandak]

@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/