Appending daily data without replacing old data in POWER BI

[sonam_2588]

Hi All, I am working on the BI Dashboard where i take Data from Web site on daily basis

I have 2 tables: Table A and Table B

on Table A i take data from website and then i insert a new column in the table and put today's date in it.

on Table B: I am appending the data from Table A on daily basis.

so for e.g. i have taken data for 25th March from website in Table A and append it in Table B.

then on 26th March as well i am repeating same and it gets appended correctly in Table B. 

however on 27th its replacing 26th Data, so on 27th i am having date only for 25th and 27th istead of 25,26 and 27.

same way on 28th  i am having date only for 25th and 28 th istead of 25,26, 27 and 28

can anyone give me solution for this? it would be highly appreciated

[Anonymous · Accepted solution]

Hi @sonam_2588 ,

You can create a custom column in Query Editor like below.

Date.From(DateTime.LocalNow())

Once you update table A, the date will update to localtime.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[amitchandak]

@sonam_2588 , Are you looking for incremental load https://community.powerbi.com/t5/Desktop/Incremental-data-load-from-Excel/td-p/140728

[sonam_2588]

i researched on it and thing is i am working on Free version of BI. so i am not able to fine Increamental load option..can you please help me on this?