Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
YangyangGao
Microsoft Employee
Microsoft Employee

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

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.

3 REPLIES 3
YangyangGao
Microsoft Employee
Microsoft Employee

hey @v-yiruan-msft 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.

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yiruan-msft
Community Support
Community Support

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 |...

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors