Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.