cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lakshmi9228 Member
Member

How to make one sheet private in a report

I would like to make one sheet not a column in a report private.
How can I do that in desktop.

Please let me know.

 

 

Thanks,

Lakshmi

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to make one sheet private in a report

No, don't click on the ellipses, just the dataset itself. You should get a blank canvas like:

 

image.png


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

10 REPLIES 10
Super User
Super User

Re: How to make one sheet private in a report

Well, you could create a separate report for that one page and share it with only the people that need to see it. Or, you could use RLS in the existing report. But, you cannot add secrurity to a page like what I think you are asking. You can hide it, but that's not really security and it is hidden for everyone.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

lakshmi9228 Member
Member

Re: How to make one sheet private in a report

So, how can we create a separate report for that one page and share it

Super User
Super User

Re: How to make one sheet private in a report

Well, the easiest way would be to copy your pbix file. Do you have a pbix file? Then in that copy remove all of your other tabs and add in the one that you want.

 

Otherwise, in the Service, just go to the Data Set and create a new report with only the page that you want.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

lakshmi9228 Member
Member

Re: How to make one sheet private in a report

I dont have an option to create a new report in my service

Super User
Super User

Re: How to make one sheet private in a report

So, in the Service, in the left nav under My Workspace, if you scroll down to DATASETS and click on the data set in question you should be presented with a blank page. You should then be able to start clicking fields to create visualizations on that page and then use File | Save or Save As to save it. What piece of that is missing for you? Is this a data set that you created and uploaded? 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

lakshmi9228 Member
Member

Re: How to make one sheet private in a report

I could see 
Rename, remove, database settings, refresj now, analyze in excel, security, manage permissions only

Super User
Super User

Re: How to make one sheet private in a report

No, don't click on the ellipses, just the dataset itself. You should get a blank canvas like:

 

image.png


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

lakshmi9228 Member
Member

Re: How to make one sheet private in a report

Thank you for your time that helped me a lot

 

lakshmi9228 Member
Member

Re: How to make one sheet private in a report

How could I create a new report in Desktop?

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,154)