How can I get Power BI Service to automatically assign gateway to new semantic model?

[Don-Bot]

I have a semantic model that is created using C# and XMLA Endpoint.  The model is created and saved in the power bi service.  

However, after the model is created it doesn't see the gateways I have setup for it to use.  Even though the service principal that is used to create the model is an admin on the connection and the gateway.  The Service Principal is also an admin on the workspace as well.  

After I create the model this is what the gateway connection screen looks like.  

However, if I simply takeover the model from the service principal that created it the service will automatically find the correct gateway.  

So how can I do this automatically so I don't have to take it over?

[Anonymous]

Hi  @Don-Bot ,

According to the error message, you are not the owner of this semantic model, you need to go to the corresponding semantic to check your permissions, if not, you can add the corresponding permissions.

Refer to:

Manage semantic model access permissions - Power BI | Microsoft Learn

Power BI Service can not automatically assign the gateway, you need to click Add to gateway in the following picture to jump to the gateway interface information to configure the corresponding data source information

Add or remove a gateway data source - Power BI | Microsoft Learn

Best Regards,

Liu Yang

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

[Don-Bot]

This semantic model was also created using an xmla endpoint (exact same code as the one not working).  The only difference is the gateway is a simple name and not a long server name.  Permissions all seem to be the same.  I haven't found any differences.

This one auto finds the correct gateway.  And as you can see this one is also owned by another ID (IE:  The service principal used by the code to create it).

I can't seem to find this one works but the other doesn't.