Forum Discussion
Direct query to another semantic model permissions - shared connections not working
Hi, we have a semantic model with some data that we want to share with the another department (model A), which is running in import mode . A user from another service would like to connect to on...
Hi MarkBurgess
The issue arises because users accessing Model B need direct access to Model A for the composite model to work. Here’s a summary of the resolution:
- Direct Access Required: Users must have at least Viewer permissions on Model A to access its data through Model B. Without this, the connection fails.
- No Proxy Connection: Even if a shared connection is created in Model B using an authorized user, Power BI does not proxy permissions. Each user must independently have access to the underlying models.
- Solution Options:
- Grant access to Model A for the required users.
- Alternatively, switch Model B to an Import mode for Model A’s data, avoiding direct dependency on permissions for Model A.
Composite models in DirectQuery require all users to have access to the connected datasets.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS