API:Dataset-Update Data Sources support ODBC connection

[Anonymous]

Hi All, Does the API:Dataset-Update Data Sources support ODBC connection??Could anyone give a clear explanation on this or if we have a blog on this !! Thanks a lot in advance!!

[v-eqin-msft]

Hi @Anonymous ,

As the official documnet said, Datesets-Update Datasources operation supports the following datasource types:

• SQL Server
• Azure SQL Server
• Analysis Services
• Azure Analysis Services
• Azure Synapse
• OData Feed
• SharePoint
• Teradata
• SapHana

For other datasource types, use Update Parameters .

You could refer to these blogs for help.

https://rapidapi.com/blog/api-glossary/parameters/

https://www.moesif.com/blog/technical/api-design/REST-API-Design-Best-Practices-for-Parameters-and-Query-String-Usage/

https://community.powerbi.com/t5/Developer/Updating-parameters-through-the-service-API/td-p/559439

https://idratherbewriting.com/learnapidoc/docapis_doc_parameters.html

https://www.designmind.com/business-intelligence/power-bi-parameters-how-to-use-parameters

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @v-eqin-msft , Thanks a lot , I will take look into this , I think as of now we don't have JSON code or API ablility for ODBC datasets which can help developers to create an API and call that in power bi service through gateways. Thanks a lot for the links..

[collinq]

Hi @Anonymous ,

I think that this question might get a better chance of being answered in the "Developer" forum rather than this one.  Other than that, this is some assistance I can find:

Datasets - Update Datasources (Power BI Power BI REST APIs) | Microsoft Docs

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[Anonymous]

Thanks I will post this in developer forum !!