Without the ability to define my model in Excel or the Power BI designer with relationships and DAX calculations and column properties/formatting, it's going to be very difficult to get my dashboards to work and look as I want. I would like to be able to upload an Excel or Power BI Designer model then use the API to push new data into it real-time. I'd also like to be able to schedule refresh and decide what happens to the API pushed data during scheduled refresh. For example, I may upload a model with 100,000 rows, then use the API to add 5,000 new rows. But during scheduled refresh those 5,000 new rows are also in my SQL source so I want to wipe out the API pushed data upon scheduled refresh.
15 Comments
- Hi Greg, this is definitely on our plan thanks. We'll be spending time on building out the APIs over the coming months. Thanks!
- Hi Will, Any update on when this functionality will be released?
- Hi, do You have any information when this functionality will be released? This would really give us a way to use thePowerBI rest api in nontrivial solutions.
Alex_J_PotterAdvocate I
Any update on this functionality?- This is a must have! Especially for IOT projects!
- This is very important and a must have feature. Its been so long, any updates friends?
- Please...this is making the difference in convincing customers to use Power BI.
- It is sad to see that the issue has not been fixed for quite some time. Could you please at least update with the schedule release date? It is a big limitation and we cannot proceed further.
- So annoying when we get no updates from the team...
- Is there any update on this matter?
