Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Direct Query Preview feature with multiple datasets

I am a new PBI Pro user with Premium.  I created a workspace with Premium content and am begininng the process of modeling against an Azure SQL database.  With the recent release of the direct query...
Need Help
  • collinq's avatar
    collinq
    4 years ago

    Hi Anonymous ,

     

    Yo ucan have more than one workspace using the same dataset.  Then when you share each workspace/report/app do NOT share the underlying data and that will keep users from getting to data that you don't want them to see AND allow you to write reports off of one dataset.  

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your reply.  It would make sense to have separate workspaces for security reasons.  But then where would I put the Constituent table (and a few others) that will be needed by each workspace?  

collinq's avatar
collinq
Super User
4 years ago

Hi Anonymous ,

 

Yo ucan have more than one workspace using the same dataset.  Then when you share each workspace/report/app do NOT share the underlying data and that will keep users from getting to data that you don't want them to see AND allow you to write reports off of one dataset.