Power BI Rest api and Direct Query

[remeezp]

Hi All,

I am currently developing a solution where a client can create their own data model using a custom built frontend.

Once the data model is published to the db, a power bi dataset is created using the api.  Currently I am pushing the data in using the api, but is it possible to link the dataset to the database using direct query through a gateway using the api?

Thanks

Remeez

[Eric_Zhang]

---

@remeezp wrote:

Hi All,

I am currently developing a solution where a client can create their own data model using a custom built frontend.

Once the data model is published to the db, a power bi dataset is created using the api.  Currently I am pushing the data in using the api, but is it possible to link the dataset to the database using direct query through a gateway using the api?

Thanks

Remeez

---

@remeezp

The answer is No. The datasets created via REST API are tagged as "PUSH" and AFAIK there's no such API that could change the dataset type. So at this moment, you can only push data using API to the datasets created via API. 

You can submit your idea at Power BI Ideas and vote it up.