Lock Fields

Anonymous — Mon, 10 Feb 2020 02:32:16 GMT

Team wants me email and share my native BI Desktop. Here, I do not want to show my all Measures i built up.

Is there any fuction to lock the Fields? with something like Password and so on.

Re: Lock Fields

dm-p — Mon, 10 Feb 2020 23:12:04 GMT

Hi @Anonymous,

I'll provide you with an answer in here - if you have any questions like this in future, it's probably better to post them in the Desktop or Service forums. There's a much higher volume of users there that can provide you with a solution more quickly than this particular forum (which is concerned with developing custom visuals using code).

What you want, specifically, is not a feature of Power BI Desktop. Desktop is not designed for sharing, but rather development of reports. Sharing is managed by publishing to the Power BI Service.

I'm not sure why you'd not want people to see your measure code - is it more that you don't want people to edit them?

If the latter, depending on the technical comprehension of your users, you have a couple of "options" if you have to feel you must stick with Desktop:

Hide all measures in report view (they'll still be able to see them if they go to the data or model views).
If your purpose is to stop users editing measures, you could share the workbook on a read-only network share. Users could still view/edit measures without saving the workbook though.

If it's more a case of wanting users to be able to configure the report and visuals using Desktop, but you want the data model to remain fixed/protected, the "Power BI way" to do it is to create a shared dataset in the service :

Publish your workbook data model to the Power BI Service as a report. This will create an accompanying dataset.
Create a new workbook and live connect to the published dataset from the last step.
Users will now be able to see the model and add their own visuals using your measures, but not see the measure code underneath.

To complete, You can copy/paste the visuals from your orignial report into a new one and then clear out visuals from the original and re-publish.

This dataset can then have its own refresh, and if you make changes then all dependent reports will see them and get the updated data.

topic Lock Fields in Custom Visuals Development Discussion

Lock Fields

Re: Lock Fields