Forum Discussion

paolomint's avatar
paolomint
Helper III
6 years ago

hide model/data view

Hello Everyone,

several people in my organization can download the .pbxi from Power bi service.

 

Is it possible to hide in the .pbxi file:

 

Data view

 

Model view

 

and Formula bar?

 

Thank you very much

Paolo

 

4 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support

    Hi paolomint ,

    It depends on your connecttion mode to your dataset. If the connection mode is Direct Query, you cannot see the Data view in the .pbix file. If the connection mode is Connect Live, both Data view and Model View cannot be seen in the .pbix file.

    Please refer:

    1. Power BI connectivity modes 
    2. Difference between live connection and direct query mode 
    3. Direct Query vs. Live Connection in Power BI 

    In addition, if you don't want to show the formula bar in the .pbix file, just not click the related measure and it will not show. If your connection mode is Import or Direct Query, you can hide the formula bar in Power Query Editors by two ways:

    1. Inside Query Editor, click on the View tab and check the Formula Bar check box.
    2. From Power BI Desktop,

      • Click File;
      • Select Options and settings;
      • Click Options;
      • In the left pane, click on Power Query Editor;
      • Check the Display the Formula Bar check box.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

  • MattAllington's avatar
    MattAllington
    Community Champion

    No, but you can stop people downloading it in the settings. Turn off export data. 

  • Disable download

    https://stackoverflow.com/questions/59401802/power-bi-service-disable-download-pbix

    https://community.powerbi.com/t5/Report-Server/Disabling-download-of-pbix-files/td-p/311125

     

    There is one more way. Create a new pbix, using this pbix. You will option in the data source as pbix . Published one will be shown there.

     

    In the new pbix Create the pages and copy-paste content from your old pbix. Select all visuals on a page and paste in this new pbix .

    In this pbix you will not have data and relation view. Publish and share this pbix. Rest you can explore.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi amitchandak, I'm trying to interpret your post but I seem to be hitting a wall. Is this guidance applicable to Power BI Desktop, or only to Power BI Service?

       

      For context, I am attempting to prepare a Power BI Desktop file which can be shared outside of Power BI Service, which would allow the recipient the ability to interact with the visualisations without seeing the underlying rows of data.