While using below power BI rest API:
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.
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!
Community Support Team _ Caiyun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.