Forum Discussion
Connecting Semantic Model to Cloud Data Source via API
Hi All, My company uses an automated process using the PowerBI Rest API to create workspaces for our clients. Previously, when we created a new workspace, the server would upload the Semantic Mod...
I know already that it is possible with this API for regular DirectQuery / Import Datasets.
It is the BindToGateway API
Datasets - Bind To Gateway In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
For Direct lake its failing because it has an issue - but I had a issue ongoing and I got told its fixed but is still pending deployment (end of Nov most likeley)
In the End you post something like
{
"gatewayObjectId": "00000000-0000-0000-0000-000000000000",
"datasourceObjectIds": ["xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"]
}
where the gatewayObjectId tells it to not use a gateway but an SCC, but the datasourceobjectid is the Id of the Cloud connection. You can get if from the Id from the PowerBI Web UI (or only via unsupported APIs I think)
I found it via some fabric docu links in the end then there
There they set it via a Fabric Notebooks rest client.
Analysis-Services/pbidevmode/fabricps-pbip at master · microsoft/Analysis-Services · GitHub
where the gatewayObjectId tells it to not use a gateway but an SCC, but the datasourceobjectid is the Id of the Cloud connection. You can get if from the Id from the PowerBI Web UI (or only via unsupported APIs I think)
I found it via some fabric docu links in the end then there
There they set it via a Fabric Notebooks rest client.
Analysis-Services/pbidevmode/fabricps-pbip at master · microsoft/Analysis-Services · GitHub
This issue is now resolved and should work now for all dataset kinds.