Skip to main content

    Developer APIs

    New

    Push data via API into an existing model

    Vote (111) Share
    Greg Galloway's profile image

    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)
    Greg Galloway's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:12:37

    RE: Push data via API into an existing model

    No updates????

    Greg Galloway's profile image Profile Picture

    29a32849 e8c9-4d96-a831-caea512f4c84 on 05 Jul 2020 23:37:24

    RE: Push data via API into an existing model

    So sad not to see any updates...

    Greg Galloway's profile image Profile Picture

    75b4a216 7cd7-4f2f-bd71-c1b4a3e3fbdd on 05 Jul 2020 23:21:20

    RE: Push data via API into an existing model

    any update on this?

    Greg Galloway's profile image Profile Picture

    1cec8555 0de0-49ea-bfc0-8c6a824f127b on 05 Jul 2020 23:10:12

    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?

    Greg Galloway's profile image Profile Picture

    f0a97b3f 76d4-e911-a996-000d3a4f3343 on 05 Jul 2020 22:43:14

    RE: Push data via API into an existing model

    Is there any update on this matter?

    Greg Galloway's profile image Profile Picture

    345b5526 4010-4e03-b23d-0a7eb7322204 on 05 Jul 2020 22:33:36

    RE: Push data via API into an existing model

    Please...this is making the difference in convincing customers to use Power BI.

    Greg Galloway's profile image Profile Picture

    169eb0ee f5cc-4cc7-b42f-b4888a9e9128 on 05 Jul 2020 22:33:32

    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.

    Greg Galloway's profile image Profile Picture

    e343aefa b8f8-4617-bf9b-19d41c7eb78a on 05 Jul 2020 22:33:08

    RE: Push data via API into an existing model

    So annoying when we get no updates from the team...

    Greg Galloway's profile image Profile Picture

    3e55589f 4c45-4dc2-a612-b43b6bf392e1 on 05 Jul 2020 22:29:04

    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?

    Greg Galloway's profile image Profile Picture

    fdbd87de 17a9-44ed-8925-9c4b0da25ccf on 05 Jul 2020 22:18:24

    RE: Push data via API into an existing model

    This is a must have! Especially for IOT projects!