cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PetyrBaelish
Resolver III
Resolver III

Hide tables in report that connects to Power Bi dataset

I have a Power BI dataset that connects (imported mode) to SQL Server. It is a fairly compex model, loosely based on a star schema, but with 3 fact tables and about 60 dimensions. I've configured scheduled refresh and a complex row level security model on it, and it serves its purpose. Some use cases have appeared however where users only need to connect to a subset of the model (e.g., 1 fact table and 10 dimension tables).

 

My plan was to create a new Power BI Desktop report, connect to existing published Power BI Dataset containing the large model, then start deleting/hiding tables that aren't needed (from the fields pane on the right hand side of PBI Desktop, where these options normally are). Unfortunately, these options aren't available (I believe this must be because I'm connecting to a Power BI dataset).

 

How else can I achieve what I want? I don't want to go back to my SQL Server data and create a fresh report, because then I would need to duplicate my security model. I want to connect to my existing Power BI dataset and then start removing entities to simplify things for my end users who only need to see a subset of the model.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@PetyrBaelish , Check if object-level security using Tabular editor can help

refer if needed

 

What is Object Level Security (OLS): https://youtu.be/u4seqaMuzM8



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

View solution in original post

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @PetyrBaelish ,

 

While connecting to dataset on Power BI Service, the connection mode is live connection which is not supported to hide tables.

You could try using DirectQuery for Power BI datasets and AS preview feature to change the connection mode to direct query. It is supported to hide tables while using direct query mode.

For more details please check the document.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s... 

In additional, you could also download the pbix from Power BI Service, hide the tables then re-publish the dataset.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix 

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User
Super User

@PetyrBaelish , Check if object-level security using Tabular editor can help

refer if needed

 

What is Object Level Security (OLS): https://youtu.be/u4seqaMuzM8



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors