The power BI rest API returns incorrect data source type

[sa1985]

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.

[v-cazheng-msft]

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]

Any update?