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 wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.