Forum Discussion
Hide Power Query transformation steps
Hi Anonymous
We can't hide steps / protect in other ways PBIX file.
But you can separate the model from reports.
And give access only to the reports pbiX.For more information please refer the linked document :
https://learn.microsoft.com/en-us/power-bi/guidance/report-separate-from-model
And tutorial:
https://www.youtube.com/watch?v=PlrtBm9YN_Q
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
Yep, you understood it right.
If your concern in this scenario is that she will download the model and see the steps, you can block this option from the admin portal, but the problem is that it will block it on the organization level, and export to Excel will be disabled too.https://learn.microsoft.com/en-us/power-bi/admin/service-admin-portal-about-tenant-settings
This all the alternatives that I know we have.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I’m using a different approach. You can create all the steps you need in Power Query, then go to the Advanced Editor and copy the full code to a new TXT file. Save the TXT file to your OneDrive. Then, go back to Power Query and use the code below to fetch the full code from the TXT file linked to your OneDrive. This way, no one will be able to access your code unless you give them permission.
let
// Fetch content from the online link
OnlineContent = Web.Contents("your_URL_here.txt"),
// Evaluate the loaded code as M code without an explicit intermediate step
EvaluatedCode = Expression.Evaluate(Text.FromBinary(OnlineContent), #shared)
in
EvaluatedCode