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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
HaiVN
Helper III
Helper III

Data sikkerhet

Hello,

I have a dataset from a survey with thousands of responders(individual data). I would like to present/ visualize the results (aggregated results) of the survey by class, gender... in power bi desktop and publish it to service og then use it to publish in a website where everyone can see the results.

I am not allowed to show the aggregated results with small number ( < 5) ( for example, total answered 'yes' i class A with gender: male is 4 ) . This will be ignored by setting av filter. 

The problem is that I am using the whole dataset ( csv file with individual data) for Power BI repport and I am not sure at the dataset can be seen or  download from public? I mean is it safe to upload Power BI report to website with dataset? 

Thank you!

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@HaiVN Well, to the best of my knowledge, Publish to Web does not allow exporting data so, in theory, you should be OK. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

9 REPLIES 9
HaiVN
Helper III
Helper III

@ArwaAldoud Thank you for your answer! I will allow everyone to se the Power Bi report ( aggrigating data)  but I do not allow them to se the datasett ( individual data)!

Hi @HaiVN ,
If you want users to view the Power BI report (aggregated data) but do not access to the dataset (individual data), follow these steps:

  • Give users Viewer access. This way, they can see the report with aggregated data.
  • Go to "Manage Permissions" and ensure that only authorized users have access to the dataset.
  • In the report settings, turn off the "Export Data" option so users can't download raw data.

If a community member’s response addressed your query, please mark it as "Accept Answer" and click "Yes" if you found it helpful.

If you have any further questions, feel free to ask.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

 

Hi @HaiVN

 

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

 

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

Hi @HaiVN ,


Just checking in to see if you've made any progress with the information provided. If you found the guidance helpful, please click "Accept Answer" and "Yes" to the question "Was this answer helpful?"

And of course, if you have any further questions or need more assistance, feel free to reach out.

 

Thank you!

ArwaAldoud
Responsive Resident
Responsive Resident

You're welcome, @HaiVN 

If Publish to Web is necessary, just ensure that individual data isn’t included in the visuals. You can do this by pre-aggregating data before uploading it to Power BI and applying filters to exclude small group counts. This way, only summarized insights are visible while keeping raw data private.

 

If this was helpful, please accept it as a solution or give kudos to help other community members

ArwaAldoud
Responsive Resident
Responsive Resident

Hi @HaiVN 
Your Power BI dataset is not publicly accessible unless you use Publish to Web, which makes the report visible to everyone. While users can't download the dataset directly, they can see all displayed data.

Greg_Deckler
Super User
Super User

@HaiVN Well, to the best of my knowledge, Publish to Web does not allow exporting data so, in theory, you should be OK. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler Thank you for your answer! Do you know where dataset is stored when we publish Power Bi repport to Power BI service? Som I understand it will be stored in Azure database which is manged by Microsoft! If yes , is it safe with data?

@HaiVN Well, the data is stored as a semantic model in the Power BI Service. The exact details are murky quite honestly. There used to be a Power BI Security white paper out there that sort of covered some of this type of stuff. Will have to see if I can find it. But, it's as secure as anything else out there in the cloud.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.