publish to web - viewing aggregated data in detail

[frankvb]

My question is about this warning: "When you use Publish to web, anyone on the Internet can view your published report or visual. Viewing requires no authentication. It includes viewing detail-level data that your reports aggregate."

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web 

How can you view this aggregate level data? 

I'm asking from the point of view of somebody publishing the report.

[frankvb]

@GilbertQ Do you know of other ways the users can view the lowest level of detail that you have in your semantic model?

These posts seem to imply that revealing more hidden detail than shown in the semantic model, or in the visuals in the report is impossible:

Solved: How to export data when published to Web - Microsoft Fabric Community

Publish to Web - Microsoft Fabric Community

Solved: Publish to Web Data Model - Microsoft Fabric Community

Some even seem to say that the line: "viewing detail-level data that your reports aggregate" is just an exaggerated warning.

As far as I can tell "viewing detail-level data that your reports aggregate" only really applies to implicit measures.

Data you aggregate not with a measure, but by using the options in the data-pane. Those can be explored with a right-click in the visual and choosing "show data-point as a table".

This functionality is not possible for data aggregated by measures:

Show the data that was used to create the report visual - Power BI | Microsoft Learn

Chris Webb's BI Blog: Is Power BI’s “Show Data Point As A Table” Feature A Security Hole? (crossjoin...

[GilbertQ]

Hi @frankvb 

I think the easiest way for you to understand this is whatever data you have in your power desktop report is the level that potentially users could see that same level of data in the power BI service.

[frankvb]

@GilbertQ 

Yes but how, is what I don't understand.

The report includes only aggregated data, all buttons for options to see more detail (view as table) or hidden

My model however includes a measure based on a hidden column. Can users somehow see the detail-data of the individual records? Via web inspector I found that you can see the hidden column: it's name and the fact it is hidden. But can you find the individual records as well?

[GilbertQ]

Hi @frankvb 

My understanding is that the users who use your reports under published web can view it down to the lowest level of detail that you have in your semantic model.