Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
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.
Proud to be a Datanaut!
Private message me for consulting or training needs.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
30 | |
24 | |
23 | |
20 |
User | Count |
---|---|
54 | |
32 | |
21 | |
20 | |
18 |