Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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