Is it possible to write data into semantic model through rest api?

[Gabry]

Is it possible to write data through the REST APIs into the tables of the semantic model, or is it only possible to read data?

[lbendlin · Accepted solution]

You can upload the entire semantic model, but not individual tables.

Note there is a slight variation to the theme when you work with push datasets.

[v-yilong-msft · Accepted solution]

Hi @Gabry ,

Just as lbendlin says, we can write data into the tables of a semantic model through REST APIs.

The method for writing data into semantic model tables is through the Push Datasets API. You can read this document for a further study:  Push Datasets API 

However you may face some limitations and permissions, here you can read this two documents: Power BI REST APIs push semantic model limitations - Power BI | Microsoft Learn and Power BI REST APIs semantic model permissions - Power BI | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

You can upload the entire semantic model, but not individual tables.

Note there is a slight variation to the theme when you work with push datasets.