Composite Model - personal vs. shared cloud connection

Hi everyone,

Thank you for your reply. Honestly, I didn't fully understand your explanation yet.

A shared cloud connection defines which user credentials should be used to access the datasource. Right now, I entered my own credentials (via Oauth2 authentification), but I could also use a service principal there. 

Obviously, I do have build permissions on the upstream semantic model.
I would expect the shared cloud connection to act in the same way as on premise data gateway connections (which also work for direct query), so that the query to the underlying data source is executed with the stored credentials.

Am I wrong with this assumption?

The main reason to use the shared cloud connection are not missing permissions in this case, but rather that I don't want to explain to everyone how to create and configure personal cloud connections.

However I figured out today that if I activate the SSO checkbox, the visuals etc. work. So for this actual problem, this solution should work for me, although I still wonder why this has to be necessary.

Maybe someone of you can provide me a link to something from the documentation, which explains why the shared connection with stored credentials doesn't work, even if the stored credentials do have sufficient permissions.