Forum Discussion

ErikVoorbraak's avatar
ErikVoorbraak
New Member
3 years ago

REST API for creating Power BI datasets, tables and columns

I'm looking for a REST API that I can use to manage Power BI datasets: create dataset, add/remove tables, add/remove columns, add/remove measures, etc. In my specific use case, I intend to consume su...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ErikVoorbraak - It is not possible to edit the Data Model (add/remove tables, add/remove columns, add/remove measures) via the Rest API.  You can only create, replace and refresh.

If you want to modify the Data Model (add/remove tables, add/remove columns, add/remove measures) you will need to use an XMLA endpoint tool.  Tabular Editor is the most popular external tool.  Try the paid version, Tabular Editor 3.  Tabular Editor 3

 

You may want to check out pbi-tools CLI | pbi-tools as this allows you to manage Power BI datasets GitHub / VS Code.

ErikVoorbraak's avatar
ErikVoorbraak
New Member
3 years ago

Hi Daryl,

 

Thank you for your answer. You wrote "You can only create, replace and refresh" - are you referring to the API documentation on https://learn.microsoft.com/en-us/rest/api/power-bi/? Looking in the section "Datasets", I cannot find a REST call to create or replace (non-empty) datasets. Should I look in a different place?