Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have a question concerning dataset permissions. I'm attempting to give users a dataset based on a SQL query from SQL Server databases. I want users to have access to all of the tools they need to create visualizations, execute transformations, and so on. However, I don't want to give them any access to the SQL server databases(not even read-only permission). What are my choices in this situation?
Power BI datasets appear to be the best option based on the possibilities I researched. Also, within my dedicated workspace group, I can control the dataset (refreshes, etc.) and the user can utilize the dataset as needed. The main difficulty here is that the user does not have access to transformation, i.e., the ability to use the Power Query editor.
Is there any other way such that when I publish the dataset in the dedicated workspace and share it with the users, they not only have the built permissions to create measures & visuals but can also use the Power Query editor without needing any rights to connect to the SQL Server database?
Thanks.
Solved! Go to Solution.
Dataflows are a good option for this scenario. A dataflow is the online (PBI Service) version of Power Query. You can create a dataflow that imports data from the SQL Server databases. Then, users can connect to the dataflow from PBI Desktop and do additional transformations in local Power Query. Users will need Viewer permission to the workspace where the dataflow resides.
Proud to be a Super User!
Dataflows are a good option for this scenario. A dataflow is the online (PBI Service) version of Power Query. You can create a dataflow that imports data from the SQL Server databases. Then, users can connect to the dataflow from PBI Desktop and do additional transformations in local Power Query. Users will need Viewer permission to the workspace where the dataflow resides.
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |