Forum Discussion
Solved
Semantic Model with direct query permissions
Hi all, I need to share some tables from our semantic model with another department. To achieve this, I created a new semantic model (B) using a direct query on the primary semantic model (A). I p...
You definately need build permission, I ran into this problem a while ago and got confirmation from Microsoft.
I think the suggestion is to daisy chain DQ over AS models to together
Import -> DQ1 -> DQ2
You would grant build permission on the DQ1 model but not the import one. DQ1 would have a subset of the tables
Hi v-pnaroju-msft,
This is exactly what I have done.
My concerns are:
- We do not want to refresh different semantic models at different times.
- To build a new report from semantic model B, I need to grant the Build permission on the main semantic model. However, based on the documentation, it seems that Read permission alone should be sufficient: https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-permissions
Thanks
Kind Regads
Giuseppe
You definately need build permission, I ran into this problem a while ago and got confirmation from Microsoft.
I think the suggestion is to daisy chain DQ over AS models to together
Import -> DQ1 -> DQ2
You would grant build permission on the DQ1 model but not the import one. DQ1 would have a subset of the tables