Forum Discussion
PabloSembaj
2 years agoRegular Visitor
Do not allow access to power query or block query viewing
Hello
I am needing to block access to transform data (power query). There are several users who have access to my pbix file and can see the queries. They can't edit data sources, but I don't want them to be able to view SQL queries. How can I block access or at least not see what the query says? If a user is positioned in the "Origin" step, they view the query.
Hide your SQL query behind a view in the SQL server. Point Power Query to the view.
1 Reply
- lbendlin
Super User
Hide your SQL query behind a view in the SQL server. Point Power Query to the view.