Forum Discussion
Hide Power Query transformation steps
Hi,
I am wondering how to hide power query transformation steps??
I initiated the development process of Power BI report in Power BI desktop. After it is completed in Power BI desktop, and I was asked to hand over to someone and she will publish in her workspace. I think this process will tranfer my developer role to her. Is that right? Can anyone confirm this? I am new to this type of process. Thanks,
I, being the developer of this Power BI report, would like to protect the transformation steps. Is there way to protect those steps? Thanks for your advice.
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
7 Replies
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
EvaluatedCodeHi 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
Thanks, Ritaf1983
I read through the document and video. From my understanding, it looks like the person who publish the report still need at least contributor access on both workspaces even tho you separate the app and dataset in two different workspaces. Did I understand it right? Thanks,
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
You can hide the steps check out the video below.
Video link: https://youtu.be/eMKah4Sml60?si=CbptvGTDN48gvCKj
