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
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
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
Thanks for your explanation. Appreciated!
Happy to help 🙂