Forum Discussion

Giu's avatar
Giu
Frequent Visitor
1 year ago
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...
Data Protection
Need Help
  • Deku's avatar
    Deku
    1 year ago

    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

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Giu,

We would like to verify whether the solution provided by Deku has resolved the issue you were facing. If you have identified another resolution, we kindly request you to share it with the community, as it could be of great help to others with similar concerns.

If you found the response useful, please mark it as the accepted solution and give kudos to support other users with comparable queries.

Thank you.