Power BI REST Api limitations while working with Gateways & Datasources

rkatta — Thu, 10 Aug 2017 07:27:47 GMT

Hi,

I am working on a solution to automate the process of the PBIX files publish to Power BI premium workspaces/Groups and auto datarefresh of datasets from the onprem underlying datasources using the latest Power BI REST API.

Following are the limitations found with the Power BI REST API for the complete automation with out any manual intervention through Power BI Service.

1) There is no method to change the URL of the underlying Datasources(Eg. Web API Url) present in Pbix file while importing into workspaces, to fetch the client specific data by passing different clientId for different clients.

2) There is no api call to fetch the underlying datasources(Eg. .xlsx file, Web Api Url, OData,..) for a dataset in Pbix file.

3) There is no proper code to create a datasource for a Gateway for underlysing datasource is of type Web Url and with Windows authentication.

4) There is no api call to add/link a dataset to the onpremises Gateway configured. Currently we need to goto Power BI Service for manual linking.

I request any help in overcoming these scenario's.

Re: Power BI REST Api limitations while working with Gateways & Datasources

KumarDarmesh — Fri, 11 Aug 2017 09:31:29 GMT

Where do you find those limitations?

Re: Power BI REST Api limitations while working with Gateways & Datasources

rkatta — Fri, 11 Aug 2017 10:07:45 GMT

These issues are found/lacking after exploring the different options given in latest Power BI REST API Reference given in MSDN

topic Re: Power BI REST Api limitations while working with Gateways & Datasources in Developer

Power BI REST Api limitations while working with Gateways & Datasources

Re: Power BI REST Api limitations while working with Gateways & Datasources

Re: Power BI REST Api limitations while working with Gateways & Datasources