Power BI Rest api and Direct Query

remeezp — Mon, 31 Jul 2017 06:19:53 GMT

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

Re: Power BI Rest api and Direct Query

Eric_Zhang — Mon, 31 Jul 2017 09:24:35 GMT

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.

topic Power BI Rest api and Direct Query in Developer

Power BI Rest api and Direct Query

Re: Power BI Rest api and Direct Query