Publish to web (public)

[Oluwajoba]

When you publish to web (public) on powerbi, is there a way to hide data while publishing? When “show data point as a table” is clicked on the visual, internal data that is not meant for outsiders is shown and that's because columns in that data were used for the visual. Please note that I don't have control of who our clients shares the report, what I mean is that they might share it whith their other colleagues so I dont have access to all their emails.

2. If I have to use Row Level Security, how do I create roles in this case for all clients not to have access to ALL DATA but can view the entire report?

[foodd]

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. Before publishing a report, make sure it's okay for you to share the data and visualizations publicly. Don't publish confidential or proprietary information. If in doubt, check your organization's policies before publishing.

Considerations and limitations

Publish to web is supported for the vast majority of data sources and reports in the Power BI service. However, the following kinds of reports are currently not supported or available with Publish to web:

• Reports using row-level security.
• Reports connecting to data using DirectQuery. Connect using composite or import mode instead. Read about the differences between the modes.
• Reports using any Live Connection data source, including Analysis Services Tabular hosted on-premises, Analysis Services Multidimensional, and Azure Analysis Services.
• Reports using a shared dataset that is stored in a different workspace from the report.
• Shared and certified datasets.
• Reports shared to you directly or through an app.
• Reports in a workspace in which you aren't an edit member.
• "R" and Python visuals aren't currently supported in Publish to web reports.
• Exporting data from visuals in a report that has been published to the web.
• Q&A for Power BI visuals.
• Reports containing report-level DAX measures.
• Single sign-on data query models, including composite models on Power BI datasets or Azure Analysis Services.
• Secure confidential or proprietary information.
• The automatic authentication capability provided with the Embed option doesn't work with the Power BI JavaScript API. For the Power BI JavaScript API, use the user owns data approach to embedding.
• Admins can block public internet access, as described in Private links for accessing Power BI. In that case, the Publish to Web option is grayed out for your tenant in the Power BI admin portal.
• License enforcement for custom visuals.
• Uncertified visuals from the organizational store, when the global tenant switch of the organization for uncertified visuals is on.
• Public visuals from the organizational store, when the global tenant switch of the organization doesn't allow visuals created using the Power BI SDK.
• The user who created the embed code needs to maintain access to the report for the embed code to work. This includes requiring a Pro or Premium Per User license as required by the workspace.
• Paginated reports

Microsoft Learn Resource (updated Sept. 7, 2023):

Publish to web from Power BI - Power BI | Microsoft Learn