Power BI Rest API

[Anonymous]

Hello Team,
I've some queries in the use case of Power BI Rest APIs. Can anyone please clarify it?

1. Can we publish a Power BI report from a Power BI Template via Power BI REST APIs?
2. Can we set the connection string or the credentials of the API data source using Power BI REST APIs?

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous,

#1, Currently power bi includes rest API to publish power bi reports, but it does not work for template files. (it store the report design and visual styles without data source)

For this scenario, I think you need to input your connection string to the template to generate your own report at first, then you can use API to publish this pbix file.

Imports - REST API (Power BI Power BI REST APIs) | Microsoft Docs

#2, Please take a look at the following link about dataset API to setting data source connection:

Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Regards,

Xiaoxin Sheng

[lbendlin]

1. No. Templates have no data and require the user to specify how to authenticate against the data sources

2. Yes, you can change any connection parameters via the REST API. 

use:

• Update Parameters In Group to update connections for SQL, Azure Synapse, OData, and SharePoint data sources.
• Update Datasources In Group to connections for other data sources.