Forum Discussion

IMett's avatar
IMett
Icon for Helper III rankHelper III
5 months ago

Composite Model - personal vs. shared cloud connection

Hi everyone, I've built a composite model with an import mode part pointing to some on premise data sources, and a direct query part which fetches data from a published semantic model. I understa...
Need Help
Murtaza_Ghafoor's avatar
Murtaza_Ghafoor
Icon for Super User rankSuper User
5 months ago

IMett collinq 

Why It Fails with Shared Cloud Connection:

When you switch to a Shared Cloud Connection, Power BI no longer uses your personal identity.

Instead, it uses a shared credential or service identity.

The problem is that DirectQuery to another Power BI semantic model usually requires the user’s identity to be passed through.

Because the shared connection cannot pass your user identity:

  • The upstream semantic model cannot verify permissions.
  • The query fails.
  • The visuals show errors.

 

That’s why everything works with Personal Cloud Connection but breaks with Shared Cloud Connection.

 

Propose Solution:

For scenarios like yours, the best approach is usually:

 

Keep using user authentication (OAuth) instead of shared credentials.

Grant Build permission on the upstream dataset to the team.

 

This allows multiple team members to work with the semantic model without breaking the Direct Query connection.


If this helps, ✓ Mark as Kudos | Mark as Solution| Help Others