Fabric REST APIs - SQL Database - Return connection details
Hi Team,
Great to get the ability to create a SQL Database via API are you working on the ability to return the connection details?
To make it more useful it would be great if we could get the connection details for the created database to (similar to how we can get in warehouse).
** Once completed can we update the offical documentation ASAP so the Terraform provided team can start using **
Return something like below:
{
"id": "5b218778-e7a5-4d73-8187-f10824047715",
"displayName": "SQLDatabase1",
"description": "A SQLDatabase description.",
"type": "SQLDatabase",
"workspaceId": "cfafbeb1-8037-4d0c-896e-a46fb27ff229"
"properties": {
"serverFqdn": "dqjx2zrgh4uejnetrut54cdkau-g3353rbpoubuvclqhgoznhkmji.database.fabric.microsoft.com",
"databaseName": "SQLDatabase1-b218778-e7a5-4d73-8187-f10824047715"
},
}
Thanks,
Darren
4 Comments
- akatesmithMicrosoft EmployeeStatus changed:NewtoCompleted
If you don't see this available already, you should see it soon.
- garddolauAdvocate IIIakatesmith Can we get the official documentation updated to please? (The terraform team will only implement changes with the provider when they see it here)
- akatesmithMicrosoft Employee
This should be documented under the GET command in the REST API. We do not return the connection string in the create command - you have to create, parse the id from the response and post a GET.
- garddolauAdvocate IIIThis is now completed and documentation updated to match
Recent ideas
Power BI Admin & Governance Center – Centralized Activity and Usage Analytics
Subject: Feature Proposal: Advanced Power BI Admin & Governance Center – Centralized Activity, Access, Sharing, Licensing and Usage Analytics Dear Microsoft Power BI Team, I would like to propose a...Dr7awb3 hours agoNew MemberNew2Views0likes0CommentsFeature Proposal: Expandable/Collapsible Page Sections for Reports on Same Semantic Model
Subject: Feature Proposal: Expandable/Collapsible Page Sections for Reports Using the Same Semantic Model Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI report...Dr7awb3 hours agoNew MemberNew3Views0likes0CommentsFeature Proposal: Fault-Tolerant Refresh, Schema Changes & Intelligent Retry
Subject: Feature Proposal: Fault-Tolerant Refresh, Schema Changes & Intelligent Retry Dear Microsoft Power BI Team, I would like to propose an enhancement to Power BI semantic model refresh behavio...Dr7awb3 hours agoNew MemberNew5Views0likes0CommentsFault-Tolerant Table-Level Refresh, Retry & Completeness Monitoring
Subject: Feature Proposal: Fault-Tolerant Table-Level Refresh, Retry & Completeness Monitoring Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI semantic model re...Dr7awb3 hours agoNew MemberNew1View0likes0CommentsAllow Measures to Be Grouped/Categorized in Matrices and Tables
Introduce the ability to group and categorize measures directly within Matrix and Table visuals, allowing report developers to organize large sets of measures into logical sections or expandable cate...Dr7awb4 hours agoNew MemberNew3Views0likes0Comments