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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
shera276
Advocate I
Advocate I

Allow external users access to Reports one Report Server

My firm uses PowerBI Report Server. I haven't seen any updates on this so I'm thinking no, but want to confirm:

 

  1. Are external users allowed to access reports on the Report Server without being on premisis (with RLS)
  2. Can we embed powerbi reports (via iframe) within our secured website that that clients can log in to (again with RLS maintained)?

 

Thanks,

 

Sheila

14 REPLIES 14
sarah23
New Member

Hello !

Was there any solution found for this issue ?

We are facing the exact same issue at my company.

YaseenJan
Frequent Visitor

Hi,

Can anyone confirm point.1 please?

Im using Power BI Report Server (sep 2019), and have a requirement to allow access of our pbi reports to external users (users not sharing our domain).

 

Is it possible now? If yes, please elaborate?

-Thanks 

Anonymous
Not applicable

 

 

We have successfully implemented anonymous access for external our users using below URL. We are using Power BI reports in our web application using iframe.

 

https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample

 

We have on-premises report server.

Anonymous
Not applicable

For 1. as far as I know it is not available yet. I would love to know if anyone has got this working.

For 2. yes it is achievable with SSAS RLS but nothing in-built from Power BI Report Server.

@Anonymous - Thank you for the response.  For #2, are you saying that we could embed the pbix (optimized for Report Server and with RLS enabled) into our secured website that external users must log in to and see the report?  I'm not technical so if this is possible could you point me to some documentation that might achieve this?  It might be ok if we bypass report server and just embed with in our secure website.

Anonymous
Not applicable

For #2, what we have done is, once the report is published to Power BI report server, we copy the report url and added it to an iFrame within our application. This works fine in our environment, although external users have to use a separate account within our AD to log in to PBIRS and look at the report. We have not find any workaround for this.

Anonymous
Not applicable


@Anonymous wrote:

For #2, what we have done is, once the report is published to Power BI report server, we copy the report url and added it to an iFrame within our application. This works fine in our environment, although external users have to use a separate account within our AD to log in to PBIRS and look at the report. We have not find any workaround for this.


I am in same situation: 

 

I have started a seperate thread as initially I did not find this thread: https://community.powerbi.com/t5/Report-Server/Embedded-Power-BI-Report-Server-and-RLS-for-Internal-and/m-p/756956/highlight/false#M11177

 

My Client wants to use "Power BI Report Server" (Power BI in On-Premises World) and NOT Power BI Service.

 

Following are the requirment:

  1. Power BI reports should be used by both internal and external users. [Note: As of now Dashboards in not a supported feature for the on-prem server:https://community.powerbi.com/t5/Report-Server/creating-dashboards-on-POWERBI-REPORT-SERVER/td-p/247...]
  2. Need to embed Power BI reports into Applications. How to do this?
  3. Application and Power BI reports should support Single Sign-On (SSO)?
  4. Embedded Power BI Reports should support Dynamic Row-Level Secirity (RLS)? [On-premises row level security with Power BI is only available with Live Connection: https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular]

Need to know out of above 4, how many can be achieved and how?

Anonymous
Not applicable

Hi,

 

Did you look at the custom authentication at this site.

https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample

 

I was able to implement this and I was succesful in deploying the applications to Report Server and then the same authenticaion linked to any client application.

 

Let me know if you need any help.

Anonymous
Not applicable

In the upcoming release in September the new filter pane will become GA in PBIRS and together with PBIRS custom authentication all of the above 4 can be achieved then, assuming you are using SSAS Tabular as your data source.

Anonymous
Not applicable

Thank you and this just might be the last nail to hit for us. I will be looking forward to enable them at work.

Anonymous
Not applicable


@Anonymous wrote:

In the upcoming release in September the new filter pane will become GA in PBIRS and together with PBIRS custom authentication all of the above 4 can be achieved then, assuming you are using SSAS Tabular as your data source.


Thanks for response. Its really a good news. 
Would you mind explaining each one that how it can be done. I need just high level. 

 

 

How did you give access for external customer in your embed url application w hilst creating a AD login in your report server? Do you copy the AD user credentials into your application.

Hi @shera276,

 

 

Embedding Power BI Reports into external application is only supported via PowerBI.com and requires Power BI Premium Capacity Subscription as far as I am aware.

 

You can embed the report server reports into internal applications.

check out the below blog post:

https://www.kasperonbi.com/embedding-power-bi-reports-with-power-bi-report-server/

 

Thanks,

Bhavesh

 

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Anonymous
Not applicable

Hi,

Did you look at the custom authentication at this site.

https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample

I was able to implement this and I was succesful in deploying the applications to Report Server and then the same authenticaion linked to any client application.

 

Let me know if you need any help.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors