cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors