cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deshant Visitor
Visitor

How to keep track of per day data.

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.

1 REPLY 1
Moderator v-sihou-msft
Moderator

Re: How to keep track of per day data.

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)