Hide Power Query transformation steps

[TANA]

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. 

[Ritaf1983 · Accepted solution]

Hi @TANA 
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

[TANA]

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, 

[Ritaf1983]

Hi @TANA 

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

[TANA]

Thanks for your explanation. Appreciated!

[Ritaf1983]

Happy to help 🙂