Reply
ccleverley
Regular Visitor

API insert new table

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.

 

?

 

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft Employee
Microsoft Employee

@ccleverley

 

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

 

Regards,

 

 

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@ccleverley

 

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

 

Regards,

 

 

 

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)