cancel
Showing results for 
Search instead for 
Did you mean: 

The power BI rest API returns incorrect data source type

While using below power BI rest API:

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/datasources

it resturns the datasource type as SQL even though actual data source type is azure sql.

 

Because of which when we are tyring to update it using update datasource api, we are getting below error:

Datasources contains invalid data source. SQL Server is not supported by the SQL Azure data extension. Please use the SQL data extension instead.

Status: Investigating

Hi @sa1985,

 

To get sql data source, you may refer to this sample: Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Docs

 

To update your sql data source including Azure SQL server, please refer to this sample: Datasets - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

 

If you still have problems on it, please let me know how’s your update data source api request body looks like. Thanks in advance!

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

Hi @sa1985,

 

To get sql data source, you may refer to this sample: Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Docs

 

To update your sql data source including Azure SQL server, please refer to this sample: Datasets - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

 

If you still have problems on it, please let me know how’s your update data source api request body looks like. Thanks in advance!

 

Best Regards,

Community Support Team _ Caiyun

sa1985
New Member

Any update?