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.
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;
Regards,
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
224 | |
53 | |
49 | |
48 | |
46 |
User | Count |
---|---|
278 | |
212 | |
113 | |
83 | |
73 |