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
Digvijay
Regular Visitor

How to create a public web URL from a Row-Level Security (RLS) report.

  • I want to create a report in Power BI and publish it on a public website. However, I would like to have five different public URLs based on specific filter conditions from a single report. Could you please guide me on how to achieve this and publish the report on the public web?
  • I want to apply filters in a way that users are unable to identify that it is a filtered report. I want each user to only see their specific report and not other users' reports.
  • I want to create a URL that does not require signing in or any credentials.
1 ACCEPTED SOLUTION
foodd
Super User
Super User

It is not possible to create a public web URL from a Row-Level Security (RLS) report.  The learn.microsoft 

limitations are listed below:

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 semantic model that is stored in a different workspace from the report.
  • Shared and certified semantic models.
  • 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 semantic models 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 secure access to Fabric. 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.
  • Multiple-language reports.

 

From <https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#considerations-a...>

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

View solution in original post

1 REPLY 1
foodd
Super User
Super User

It is not possible to create a public web URL from a Row-Level Security (RLS) report.  The learn.microsoft 

limitations are listed below:

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 semantic model that is stored in a different workspace from the report.
  • Shared and certified semantic models.
  • 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 semantic models 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 secure access to Fabric. 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.
  • Multiple-language reports.

 

From <https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#considerations-a...>

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

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.

Top Solution Authors