Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

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:


Cattura.JPGData view


Model view


and Formula bar?



Thank you very much



Community Support
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.Toggle-formula-bar.gif
  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.Toggle-formula-bar-2.gif


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.


Super User IV
Super User IV

Disable download


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.




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors