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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
eddydm
Advocate II
Advocate II

Can security be setup concerning the visibility of the dataset

Is it possible to put some security on a report (published to a workspace) use by the power bi service so that a user can see the whole report, but can't see the dataset used in this report?

I don't mean RowLevelSecurity. I want a user to see the report. He may see all the data regarding a visualisation (lets say the export of a table to see how many male/females there are in a company), but not the whole dataset (lets say the list of staffmembers with names, gender, birthdays, ... )

 

Thanks in advance for any idea/solution.

 

 

2 ACCEPTED SOLUTIONS
ankitpatira
Community Champion
Community Champion

@eddydm When you share a dashboard with the users they see dashboard and report behind it but not the dataset. 

View solution in original post

greggyb
Resident Rockstar
Resident Rockstar

With access to a dashboard the end users will have access to Q&A on the dataset(s) behind any of the visuals in the dashboard.

 

Even if you disable the display of the Q&A search box on the dashboard, an end user can trivially access Q&A by appending "/qna?q=" to the URL of the dashboard.

 

If the dataset does not support Q&A (e.g. a live connection to SSAS), then this would not be a concern.

 

The distribution methods that will support this are sharing of a dashboard or view-only membership in a group workspace. A content pack will always include the dataset.

View solution in original post

6 REPLIES 6
greggyb
Resident Rockstar
Resident Rockstar

With access to a dashboard the end users will have access to Q&A on the dataset(s) behind any of the visuals in the dashboard.

 

Even if you disable the display of the Q&A search box on the dashboard, an end user can trivially access Q&A by appending "/qna?q=" to the URL of the dashboard.

 

If the dataset does not support Q&A (e.g. a live connection to SSAS), then this would not be a concern.

 

The distribution methods that will support this are sharing of a dashboard or view-only membership in a group workspace. A content pack will always include the dataset.

@greggyb Thanks for the info. I will accept it as a solution for my problem, because you informed me about those risks. It's not a real solution for my problem. I think it is not possible to make the dataset invisible (except by using SSAS which is not implemented in our company).

The dataset is not visible in Publish To Web.  Only the Report Pages can be viewed.

www.CahabaData.com
greggyb
Resident Rockstar
Resident Rockstar

Any live connection or DirectQuery source will behave the same. It is imported data models that pose the risk with Q&A

CahabaData
Memorable Member
Memorable Member

Also the Publish-to-Web feature will achieve what you seek.

 

www.CahabaData.com
ankitpatira
Community Champion
Community Champion

@eddydm When you share a dashboard with the users they see dashboard and report behind it but not the dataset. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.