Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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
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 @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
Thanks for your explanation. Appreciated!
Happy to help 🙂
User | Count |
---|---|
85 | |
85 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |