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? ...
Tutorial Requests
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

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.