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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ohappyday
Frequent Visitor

Power BI - Does Sharing A Dashboard (Pinned Live Page) Expose The Underlying Data? Privacy Security

I have pinned a live page from a Power BI report to a dashboard, then shared only the dashboard with a person in my organization.  That person was not able to see underlying data.  Still, the permissions in the service now added that person to the dashboard, report, and semantic model.

I think/hope that the data is shared only as aggegated counts for the dashboard, but I have to be certain before proceeding further.  I've read a good deal of documentation and am just not sure what the privacy status of the data is.

 

@privacy 

2 ACCEPTED SOLUTIONS
aj1973
Community Champion
Community Champion

Hi @Ohappyday 

Best practice is to separate the report and dashboard from its dataset into 2 different WS and publish the dashboard into an App. Add the user to the audience of the dashboard then go back to the dataset and set Permissions to the user as a view on it. 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

aj1973
Community Champion
Community Champion

For this you need 2 Workspaces A and B:

  • Publish the report with its Dataset into A
  • Open the report and download the report like thisaj1973_0-1702073272411.png

     

  • Open the report in your desktop, connect it to the dataset in WS A
  • Publish the report into WS B
  • Go back to WS A and delete the report but keep the dataset

You will have both of them seprated.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

7 REPLIES 7
aj1973
Community Champion
Community Champion

Hi @Ohappyday 

Best practice is to separate the report and dashboard from its dataset into 2 different WS and publish the dashboard into an App. Add the user to the audience of the dashboard then go back to the dataset and set Permissions to the user as a view on it. 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hi Amine,

 

Thank you for your response.  Can you tell me how to separate the report and dashboard from the dataset?  I am very inexperienced with Power BI, though I

hope for that to change in the near future

 

 

aj1973
Community Champion
Community Champion

@Ohappyday 

This video is a good example https://www.youtube.com/watch?v=v3FlNhpyrz0

There is also another way, little longer but easy... Let me know if you didn't like the video way 🙂

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

The video seems useful, but requires a few external tools.  I'll have difficulty getting permissions internally to use them.  Could you share the alternative approach?

aj1973
Community Champion
Community Champion

For this you need 2 Workspaces A and B:

  • Publish the report with its Dataset into A
  • Open the report and download the report like thisaj1973_0-1702073272411.png

     

  • Open the report in your desktop, connect it to the dataset in WS A
  • Publish the report into WS B
  • Go back to WS A and delete the report but keep the dataset

You will have both of them seprated.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thanks very much Armine!  Actually easier than I anticipated.  Confirming - this process allows secure publishing of the dashboard with live pinned page, without exposing the underlying data, yes?

aj1973
Community Champion
Community Champion

Yes and No, 

To cover all security aspects, Workspaces should only be accessed by Members and/or collaborators. End users should be added to security AD Groups to consume the Reports/Dashboards in the production environment  which is the App and grant permission to that security Group as Viewer directly at the semantic model Level. 

You are welcome

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.