topic Any user facing restful data source connection API to create a data source connection ? in Developer

Any user facing restful data source connection API to create a data source connection ?

YangyangGao — Fri, 02 Aug 2024 09:24:59 GMT

Does Fabric has any user facing restful data source connection APIs can be used to

1. Post - Create a data source connection to connect to external blob storage (global or binding to a specific artifact ?).

2. Get - Get the data source connection via id/name to get the connection credentials to for code experience.

I want let anyone help for above questions, assume I am a data engineer and I want to access some my own external data sources via Fabirc Notebook but I don't want to explicitly hardcode the credentail info. So it's better if we have rest API call can be use to create/get a data connection.

Re: Any user facing restful data source connection API to create a data source connection ?

Anonymous — Mon, 05 Aug 2024 06:49:38 GMT

Hi @YangyangGao ,

Base on your description, it seems like you are trying to create a connection to Power BI via REST API without hardcoding credentials and access an external data source through Fabric Notebook.

1. Create a Data Source Connection

OAuth 2.0 client credentials flow on the Microsoft identity platform - Microsoft identity platform | Microsoft Learn

How to create a REST connection - Microsoft Fabric | Microsoft Learn

2. Retrieve Credentials in Your Notebook

powerbi - Power BI and Azure Key vault - Stack Overflow

Bring your own encryption keys for Power BI - Power BI | Microsoft Learn

3. Access External Data Source via Fabric Notebook

Load data into your lakehouse with a notebook - Microsoft Fabric | Microsoft Learn

Best Regards

Re: Any user facing restful data source connection API to create a data source connection ?

YangyangGao — Thu, 08 Aug 2024 08:55:26 GMT

hey @Anonymous thanks but it actually can't solve my request. Actually want i want is a rest API which can be use to create a DMTS data connection. I think the answer is no based on my current investigation. I will raise the question internally, and mark this question done.

Re: Any user facing restful data source connection API to create a data source connection ?

Anonymous — Tue, 13 Aug 2024 07:28:10 GMT

Hi @YangyangGao ,

I apologize that my previous reply did not resolve your problem. If you find a solution, could you kindly share it here at your convenience? This will greatly assist others in the community who may encounter similar problems. Thank you for your efforts.

Best Regards