Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to Solution.
@eddydm When you share a dashboard with the users they see dashboard and report behind it but not the dataset.
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.
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.
Any live connection or DirectQuery source will behave the same. It is imported data models that pose the risk with Q&A
Also the Publish-to-Web feature will achieve what you seek.
@eddydm When you share a dashboard with the users they see dashboard and report behind it but not the dataset.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
28 | |
26 | |
22 | |
22 | |
18 |
User | Count |
---|---|
51 | |
34 | |
28 | |
24 | |
21 |