How can we improve Power BI?

Update rows Rest API

Provide API to update rows in an uploaded dataset

172 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Sauskethorpido shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

32 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • tchua commented  ·   ·  Flag as inappropriate

    I'm stuck with a simple service because this feature is not available. Neither does it seem possible to create a unique primary key in the tables to avoid duplicate entries. Not sure how this does not have priority over other features.

  • Alex commented  ·   ·  Flag as inappropriate

    deto - we need to be able to update datasets. Otherwise this feature is unusable for us as an ISV

  • Anonymous commented  ·   ·  Flag as inappropriate

    I need this feature too.

    The workaround of deleting then adding new data right after causes the dashboard tiles to display (BLANK) for a few seconds, making that approach unusable.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Yes.. this is a must to have feature. Cant imagine basic CRUD operations missing in a microsoft product.

  • Raju commented  ·   ·  Flag as inappropriate

    Hi, Any update on this change request. I am also having problem to add records in existing dataset (created by uploading the pbix file from desktop). I want to refresh the dataset by sending new rows via rest api.

  • martin knight commented  ·   ·  Flag as inappropriate

    is this going to happen? having to delete all the rows of data and reinsert them all just because 1 field in 1 row has changed seems like a bad idea.

  • Alison Hughes commented  ·   ·  Flag as inappropriate

    Ability to search for a set of rows and alter them would save a lot of data refresh traffic. If a row is added incorrectly then the only way to correct this is to delete all the rows and re add. I am dealing with large quantities of data, so the rebuild can take hours, and hitting powerbi with thousands of add row requests.

  • Favna commented  ·   ·  Flag as inappropriate

    More than 2 years since this was opened and still nothing? This is super super essential of any Database. Did no one teach PowerBI about CRUD (Create Read Update Delete)?

  • Steve Menke commented  ·   ·  Flag as inappropriate

    I just started to look into use push data sets and I updating rows is a common use case for my data. So this is a must have.

  • Zeeshan Qadir commented  ·   ·  Flag as inappropriate

    @charles sterling (Admin, Microsoft Power BI)

    Any update on this feature request? Is this feature coming or it's discarded by the team?

  • Arunkumar T D commented  ·   ·  Flag as inappropriate

    This is must to have. Even in Delete option, all the records are deleted. not a specific row. This is making us handicap to provide solution for the tables with 100,000+ records. This is very impractical to delete and insert rows every time. Please enable this feature ASAP.

  • Mo commented  ·   ·  Flag as inappropriate

    Also want to ask if there has been any progress in the last 6 months?

  • Anonymous commented  ·   ·  Flag as inappropriate

    Charles Sterling, has there been any progress in this issue? Or is there a timeline for implementing this feature?

  • Anonymous commented  ·   ·  Flag as inappropriate

    I would like to be able to add a row to a table called say: DataSource and then use the data in this table as a dynamic programmable parameter.

    I can then:
    - publish a .pbix file through REST API
    - update DataSource table through REST API
    - On refresh new DataSource path is used to get data

    This means I can completely automate publishing of PowerBI Dashboards for new clients.

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.