Forum Discussion

PabloSembaj's avatar
PabloSembaj
Regular Visitor
2 years ago
Solved

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

  • Hide your SQL query behind a view in the SQL server.  Point Power Query to the view.