Forum Discussion

tvaishnav's avatar
tvaishnav
Helper IV
3 years ago

Prevent user of data flow from accessing data source

I am working on creating a dataflow. I am pulling tables from SQL server database using a service account that has full read access to the database.

 

I want other users to use this data flow to create reports. I also want to give them ability to create new queries by manipulating existing queries. But I do not want them to pull new data from data source. Is that possible?

Data Protection
Need Help

1 Reply

  • collinq's avatar
    collinq
    Super User
    3 years ago

    Hey tvaishnav ,

     

    If you give them access to the dataflow as a datasource but don't give them access to the workspace that has the dataflow you should not have any issues.  Basically, that allows them to see the results of the dataflow but not get into the dataflow itself and manipulate it.