Problem while setting up shareable cloud connection

[Gabor_Kelemen]

Hi!

I have a problem with setting up a shareable cloud connection.

I have a semantic model in a pro workspace. Due to technical limitations I need to have multiple connections with the same web (REST API) datasource with different credentials. There are some endpoints where normal basic auth is sufficient, but there are others where I need to create a post request hence I need to set up authentication in headers and setting the connection to anonymus.

With personal cloud connections I cannot solve this as there I cannot have different credentials, authentication modes. I've created a new shareable cloud connection. When I try to set it up on the semantic model I get an error message. What could be the reason? Do I miss something?

There are only cloud datasources so normally I don't need any gateways.

Thank you in advance!

[Anonymous · Accepted solution]

Hi @Gabor_Kelemen 
Thank you for reaching out microsoft fabric community forum. 

It looks like your Pro workspace does not support Shareable Cloud Connections, which require a Fabric or Premium Per User (PPU) workspace. You may need to move your semantic model to a Fabric Capacity workspace to enable this feature.

Additionally, Microsoft Fabric does not currently allow multiple connections to the same REST API with different credentials in the same workspace.

Please try the following workarounds:

• Create Separate Shareable Cloud Connections Instead of a single connection, set up different cloud connections for each authentication method.
• Use dataflow gen2 where it can retrieve data from the API using different credentials and store it in a Lakehouse or Warehouse for the semantic model to utilize.

If necessary, you can create different workspaces with different connection configurations.

If you need any further assistance or have any questions, please feel free to reach  us.

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.

[Gabor_Kelemen]

Thank you for your quick reply!

I've tried to do this in a PPU workspace but wasn't able to set the shareable cloud connection to the semantic model. As we don't have fabric capacity and in the near future we won't have that I cannot create dataflow gen2.

I could however solve the issue in a not too elegant way. I had a technical account as well besides my personal account so I made the other connection as a personal cloud connection but in the name of a different user.