How to keep track of per day data.

[deshant]

Hi all,

I have a table in which have some data for a day.  This table keeps on refreshing after each 12 hr. Now i need to plot the dashboard from this data. As per day i am getting more than 20K entries so i can not dump all these data in a single file before refresing it. So could any one help me how to plot dashbord from this sinario.

[v-sihou-msft]

@deshant

Currently, it's not supported to incremental load the data into Power BI. Please vote the idea.

For your requirement, you can extract your table into a new file under same folder every, then get data from that folder.

Another approach is using R script to write the table into a file with "append=TRUE". Then you just need to get data from that file. See: How to create a Load History or Load Log in Power Query or Power BI

Please refer to a similar thread below;

https://community.powerbi.com/t5/Desktop/Save-old-and-append-updated-data-into-an-additional-table/t...

Regards,