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 (7)
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.
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.
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.
RE: Update Dataset using Power BI REST API
how can i update my relationship schema in powerbi api?
RE: Update Dataset using Power BI REST API
Also need to add/remove table from an dataset
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.
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