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.
11 Comments
- 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
- 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.
- Also need to add/remove table from an dataset
- how can i update my relationship schema in powerbi 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.
- 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.
- 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.
- 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
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?
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.
Recent ideas
notebookutils.runtime.context['userName'] doesn't work for Workspace Identity or Service Principal
Please make notebookutils.runtime.context return the name of the Workspace Identity or Service Principal when running a notebook under such identities. userId is populated with the object id of the ...
