API insert new table

[ccleverley]

Hi:

    I can use the API to create a dataset, I then create 1 table inside the dataset while creating the dataset. I can use the API to load data into my dataset.

    I now want to create a new table inside the dataset. 

   I tried to post to  https://api.powerbi.com/beta/myorg/datasets/<<my long dataset id>>/tables

   I have also tried to recreate my dataset - but then I get a new dataset with just the new table.

  If posting to https://api.powerbi.com/beta/myorg/datasets :creates a new dataset,.

                      https://api.powerbi.com/beta/myorg/datasets/<<my long dataset id>>/tables/<<my table>>/rows : creates a new row, then I thought it logical that https://api.powerbi.com/beta/myorg/datasets/<<my long dataset id>>/tables would create a new table.

?

[v-sihou-msft · Accepted solution]

@ccleverley

Currently, Power BI REST API doesn't support adding Table into existing Dataset. You have to recreate you Dateset.

Regards,

[ccleverley]

I understand, and in general things work well and so I am not complaining.

But, for low code programming environments, the goal is to deliver to customers software which can be easily cusomized. The customer will make their own views and even tables.

The customer can then easily export the new tables or views to PowerBI, but that means wiping out their old dataset and recreating. (The minus there is that historical data is lost.) Or the customer can create a new dataset - with no table relations to their already exported tables. The minus there is that they can not join their new data to the old data.

Also for existing integrations new versions of an interface will have new tables which again will wipe out old data. Thus compairsons between the current state of a project against 1 year ago will not be possible.

I am not complaining, but I think that there are times when an add table is good.