Skip to main content

    Power BI

    Needs Votes

    Update Dataset using Power BI REST API

    Vote (68) Share
    Minsuk Kang's profile image

    Minsuk Kang on 06 Aug 2016 23:11:00

    It's good to have Power BI REST API for creating Datasets.
    It'd be really good to be able to change Datasets schema using Power BI REST API. Otherwise, it's impossible to make changes (i.e. relationships) on existing Dataset which all reports are dependent on.

    Comments (10)
    Minsuk Kang's profile image Profile Picture

    on 05 May 2023 13:03:37

    RE: Update Dataset using Power BI REST API

    I need to add new tables and relationships to an existing dataset via REST API without having to delete the dataset and create a new one, for my company it is a priority.

    Minsuk Kang's profile image Profile Picture

    Praveen Nagpal on 20 Jul 2022 08:22:46

    RE: Update Dataset using Power BI REST API

    We still have a problem with not being able to create new tables using push data set on existing schema even after 6 years it was raised. Is there a workaround for this?

    Minsuk Kang's profile image Profile Picture

    Adrian Nankivell on 07 Oct 2020 00:02:38

    RE: Update Dataset using Power BI REST API

    As someone else commented - after the ability to add a new table.

    We can already alter the structure of an existing table using PutTable/PutTableInGroup - but would like to extend an existing dataset, rather than destroy it (and all related reports) and create another from scratch just to add another (related) table

    Minsuk Kang's profile image Profile Picture

    Lars Kemmann on 05 Jul 2020 23:36:57

    RE: Update Dataset using Power BI REST API

    Yes, adding new tables, relationships, and measures is vital to being able to maintain datasets programmatically!

    I'm building a multitenant IoT solution that will cause all kinds of headaches for customers if I can't make additive changes to existing datasets.

    Minsuk Kang's profile image Profile Picture

    Paul Cable on 05 Jul 2020 23:35:22

    RE: Update Dataset using Power BI REST API

    To clarify, we're after the ability to add new Tables to existing datasets. The existing api allows us to change the schema of existing tables, it just doesn't seem to support adding new ones.

    Minsuk Kang's profile image Profile Picture

    IM on 05 Jul 2020 23:19:02

    RE: Update Dataset using Power BI REST API

    why is this not a priority / has it not been addressed for nearly 2 years?

    not having this completely destroys efficiency in using the powerbi api, and will drive away users.

    note that below answers do not address the issue of changing Table Names, or adding / removing Tables.

    Minsuk Kang's profile image Profile Picture

    nupur solanki on 05 Jul 2020 22:46:29

    RE: Update Dataset using Power BI REST API

    how can i update my relationship schema in powerbi api?

    Minsuk Kang's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:41:58

    RE: Update Dataset using Power BI REST API

    Also need to add/remove table from an dataset

    Minsuk Kang's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:29:59

    RE: Update Dataset using Power BI REST API

    Adjust your json table file to meet the requirements of your changed schema and then do a PUT to the table via the API. I've done this a few times now. Seems to work fine.

    Minsuk Kang's profile image Profile Picture

    Hiren Sangani on 05 Jul 2020 22:28:07

    RE: Update Dataset using Power BI REST API

    Apparently according to Power BI documentation, you cannot update dataset which comprises your multiple tables.

    However you can update their existing schema using following API:

    http://docs.powerbi.apiary.io/#reference/datasets/table/update-an-existing-tables-schema