Forum Discussion
Create connection to semantic model using fabric resp api
Perfect, this clarification makes a world of difference, let's go one point at a time:
#1. Start with "Is Power BI Semantic Model connection type via the API" and the answer is NO, I got the JSON list from https://api.fabric.microsoft.com/v1/connections/supportedConnectionTypes there are 246 supported types, but not Power BI Semantic Model
#2. Then how is this created? When you configure a semantic model refresh in the Fabric portal, it creates a connection object internally that appears as "Power BI Semantic Model" — but this is not a standalone connection type you can create via the /connections endpoint, you can however, create this types of conections manually via the portal
or via the data pipeline as you shown before
And then bind this connection via fabric-rest-api-for-connection-binding-of-semantic-models
#3. So what's possible? Unfortunately, this seems to be one case where seems like a fully automation is not yet possible the exact way you wanted, until this connection can be created by API, therefore, the closes strategy is manually create the "Power BI Semantic Model" connection up-ahead in the portal and then use the Bind Semantic Model Connection API to associate it with other semantic models programmatically.
I know is not the answer you wanted to hear , but it's the answer to your question (don't kill the messanger hehehe)... wish in the near future all connections will be possible via the API.
Hopefully you accept this as valild once confirmed the information provided, if you deemed appropiate, accept this as a solution and kudos for the information provided. All the best mate.
Sorry, I didn't describe the problem clearly.
I have the pipeline that will refresh my semantic model. It uses connection called Fabric Connector as shown below.
I created this connection mannualy.
But now I need to publish this pipeline to another tenant that doesn't have this connection yet. Trying to publish without creating a connection throws an error. So I need to create this connection before publishing. The problem is that I can't build the correct JSON body to create the connection. I'm using
https://api.fabric.microsoft.com/v1/connections
Perfect, this clarification makes a world of difference, let's go one point at a time:
#1. Start with "Is Power BI Semantic Model connection type via the API" and the answer is NO, I got the JSON list from https://api.fabric.microsoft.com/v1/connections/supportedConnectionTypes there are 246 supported types, but not Power BI Semantic Model
#2. Then how is this created? When you configure a semantic model refresh in the Fabric portal, it creates a connection object internally that appears as "Power BI Semantic Model" — but this is not a standalone connection type you can create via the /connections endpoint, you can however, create this types of conections manually via the portal
or via the data pipeline as you shown before
And then bind this connection via fabric-rest-api-for-connection-binding-of-semantic-models
#3. So what's possible? Unfortunately, this seems to be one case where seems like a fully automation is not yet possible the exact way you wanted, until this connection can be created by API, therefore, the closes strategy is manually create the "Power BI Semantic Model" connection up-ahead in the portal and then use the Bind Semantic Model Connection API to associate it with other semantic models programmatically.
I know is not the answer you wanted to hear , but it's the answer to your question (don't kill the messanger hehehe)... wish in the near future all connections will be possible via the API.
Hopefully you accept this as valild once confirmed the information provided, if you deemed appropiate, accept this as a solution and kudos for the information provided. All the best mate.
Thank you!