Greg Galloway on 02 Jan 2015 15:46:09
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.
Administrator on 03 Jan 2015 02:48:05
Hi Greg, this is definitely on our plan thanks. We'll be spending time on building out the APIs over the coming months. Thanks!
- Comments (13)
RE: Push data via API into an existing model
No updates????
RE: Push data via API into an existing model
So sad not to see any updates...
RE: Push data via API into an existing model
any update on this?
RE: Push data via API into an existing model
This was "planned" 3 years ago... is it still going to happen?
What's the point in being able to push data through the API if we can't add rows to an existing dataset? It wouldn't be as big of an issue if it were possible to at least have the full Desktop functionality using a data source from the PBI Service, but neither way works currently?
RE: Push data via API into an existing model
Is there any update on this matter?
RE: Push data via API into an existing model
Please...this is making the difference in convincing customers to use Power BI.
RE: Push data via API into an existing model
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.
RE: Push data via API into an existing model
So annoying when we get no updates from the team...
RE: Push data via API into an existing model
This is very important and a must have feature. Its been so long, any updates friends?
RE: Push data via API into an existing model
This is a must have! Especially for IOT projects!