Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, folks
I started playing with Power BI a few days ago, fetching data from our provider of maintenance system with REST/JSON. I was able to get all records (~5k maintenance work orders, what required about 30 minutes to load) using the server's pagination procedure (500 records per page).
Now, I wanted to refresh changed orders, without the need to refresh the full data, to speed up the process. The server is able to deliver me only changed orders, but I could not find how to set up the query this way.
For the pagination I was able to merge the results into one table, but how could I set up the update to the same table?
Thanks, and regards,
Mauricio
Solved! Go to Solution.
You may check if the post below helps.
https://community.powerbi.com/t5/Developer/Updating-Data-with-Push-Push-Data-Sets/m-p/898558#M21982
You may check if the post below helps.
https://community.powerbi.com/t5/Developer/Updating-Data-with-Push-Push-Data-Sets/m-p/898558#M21982
Looks promissing, let me read about it a little bit more, but that could be the answer!
Regards
Refresh data
Do one of the following:
To refresh the records in Datasheet or Form view, on the Home tab, in the Records group, click Refresh All, and then click Refresh.
To refresh the records in PivotTable or PivotChart view, on the Design tab, in the Data group, click Refresh Pivot.
Press SHIFT+F9.
Refer if this can help https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
Hi,
check if this can help. You'll find this dialog right clicking a table in model view .
Regards FrankAT
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |