Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Prevent users from expanding dataset

Hi everyone,

 

What i want to do is share a dataset that i have created with other users in my organization.

Is it possible to publish a dataset and let users create reports using this dataset, without giving them the option of changing the dataset. What i want is for them to come to me if they wish to access another table, so i can add it to the dataset and republish it.

 

My initial thought was to create a app workspace where i would have Row Level Security filters, but if they can still add other tables that are not accounted for, then i'd have to filter each and every table in my database, which is not happening. :D

 

So, can i allow my users to use the dataset to create reports without giving them access to the rest of the data.

Otherwise i have to do it through the SQL server, which would be quite a hassle.

Is there a nice option that i haven't thought of?

 

Thanks for any help. :)

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Yes, that's the solution. If the users have the access to the SQL Server, they can create a new PBIX even if you restrict the access in one PBIX file. So you should control it in the data source.

     

    Best Regards,
    Dale

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    Maybe you can hide some tables. Please refer to the snapshot below.

    Prevent-users-from-expanding-dataset

     

    Best Regards,
    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      That would work if my user only used it in the browser, but wouldn't they still be able to see the hidden tables if they download the .pbix file or dataset. 

       

      What i want is a dataset that they can use in the desktop version to create reports, but they can not be allowed to DirectQuery new tables or fields into the dataset.

       

      I'm thinking that if i remove their rights to read the SQL server, then they can download the dataset, create reports from it and upload it to the app workspace, where it then would be connected to the data gateway to refresh.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous,

         

        Yes, that's the solution. If the users have the access to the SQL Server, they can create a new PBIX even if you restrict the access in one PBIX file. So you should control it in the data source.

         

        Best Regards,
        Dale