Forum Discussion

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
5 years ago

POWER QUERY SECURITY - Is possible to secure PQ Development Steps and Logic for POWER BI pbix file

Hi,

 

I want to implement Power Query Development Step and Logic security, Is it possible to create for pbix files...

 

Lot of Thanks in Adavnce

data protection
Need Help

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi PijushRoy 

    I'm not really sure what you mean, can you explain a bit more clearlywhat you are trying to do?

    Regards

    Phil

    • PijushRoy's avatar
      PijushRoy
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Hi PhilipTreacy 

      I have pbix files and need to share with my client. So I want to the client could not able to see power query steps, technique and most important not able to make any changes in POWER QUERY or PBIX file.

      • mahoneypat's avatar
        mahoneypat
        Icon for Microsoft Employee rankMicrosoft Employee
        5 years ago

        You can't make a pbix read only, but you could publish the report to create a dataset and build the report based on that.  You could also create dataflow(s) from your query and use that to build the report.  In either case, the consumer would not be able to modify the query (assuming you restrict access on the workspace that has the dataset or dataflow.

         

        Regards,

        Pat