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
You could use the analysis service connector in power query and they could import only the tables they need.