topic Re: Embed Power BI report in web application using Power BI Report Server in Report Server

Embed Power BI report in web application using Power BI Report Server

jimmymitra — Fri, 17 Nov 2017 11:25:54 GMT

Can anybody tell me if I use the on-premise power BI report server option , will I be able to to embed reports into my internal web application ?

Re: Embed Power BI report in web application using Power BI Report Server

Jon-Heide — Sat, 18 Nov 2017 00:55:41 GMT

Yes, using an IFrame and setting "?rsembed=true" appended to end of URL.

Re: Embed Power BI report in web application using Power BI Report Server

jimmymitra — Mon, 20 Nov 2017 09:37:45 GMT

Okay , but can I build a solution within Power BI Report Server so that the embedded content shown on the reports need to vary according to the user role (District Manager , Area Manager etc) ,

My client does not want the users to explicitly log-in to Power BI , they will log-in to the internal application where the power BI report will be embedded , Login will use the windows AD authentication.

But user will not log-in explicitly to Power BI , there needs to be some connection string passed to Power BI from the application that will tell Power BI who the user who logged in to the application and viewing the report.

Not all users will have access to all the reports , neither all have access to all the data ,

Please suggest if this kind of solution can be built using Power BI Report Server on premises

I know this can be buit in Power BI report services using Power BI embedded license , but need to check the same can be done with the on-premises solution , if can not be done , then on-premise solution of power BI is of no use to us at this point

Re: Embed Power BI report in web application using Power BI Report Server

muchinski — Mon, 20 Nov 2017 10:12:30 GMT

Hello jimmymitra,

Yes, it can be done!

by default, the Power BI Report Server uses windows authentication, so the users are not prompted for logins.

You can filter the data by the Username() functin using the RLS (Row Level Security) feature of the tabular model, and make a live connection of your power BI reports to the Tabular. In my point of view, this is the best approach for your problem ;)

Re: Embed Power BI report in web application using Power BI Report Server

jimmymitra — Mon, 20 Nov 2017 11:26:35 GMT

Is it necessary to use tabular model , we are not using SSAS tabular , instead planning to use the Power BI Modelling and direct query to SQL.

I am concerned there might be some challenges with Power BI Report Server ,

And since anyway Premium license is required for this , then why not use more conventional solution -like power BI service in the azure

Re: Embed Power BI report in web application using Power BI Report Server

muchinski — Mon, 20 Nov 2017 12:00:27 GMT

jimmymitra wrote:
Is it necessary to use tabular model , we are not using SSAS tabular , instead planning to use the Power BI Modelling and direct query to SQL.
No, it is not necessary, you can do it with multidimensional too. I am not sure about embeded power BI models - need to test. Regarding to SQL direct queries and RLS, this is in preview, so I believe that it works only on the cloud

I am concerned there might be some challenges with Power BI Report Server ,
We are using it since the first releases and no problems so far (I have to say: It is working gracefully), but we have a team already experienced with Microsoft BI.

And since anyway Premium license is required for this , then why not use more conventional solution -like power BI service in the azure
You can have it with SQL Server Enterprise + SA. Maybe you are the best guy to answer if you need it on cloud or on premisses.

Re: Embed Power BI report in web application using Power BI Report Server

jimmymitra — Mon, 20 Nov 2017 12:18:19 GMT

Thanks a lot for the clarification ,

Just to ensure I understand correctly the below statement -

No, it is not necessary, you can do it with multidimensional too. I am not sure about embeded power BI models - need to test. Regarding to SQL direct queries and RLS, this is in preview, so I believe that it works only on the cloud

So does it mean Direct Query to SQL database and RLS is not supported in the latest release of Power BI report server , If that is the case we can not use it as we have requirement for both direct query and RLS

Re: Embed Power BI report in web application using Power BI Report Server

muchinski — Mon, 20 Nov 2017 13:37:04 GMT

No and Yes, I will explain:

NO: So far, you cannot use the Power BI role feature for implementing a RLS to filter direct query using the report services

...BUT...

YES: if you have implemented the RLS in the data source (ie: using views that filter the data that the user can see), and your data source are these views. Remember to keep Windows integrated security on the data sources - you may have to configure kerberos delegation if the database is not on the same server as the report server - but this is expected.

(I hope you got it and set this as the answer - because it took me some time testing...heheh)

Re: Embed Power BI report in web application using Power BI Report Server

gemidriver — Tue, 29 May 2018 21:19:41 GMT

got it working in our environment

append

?rs:embed=true

BOOM!

Re: Embed Power BI report in web application using Power BI Report Server

muchinski — Tue, 29 May 2018 21:26:32 GMT

I suggest that you create another topic and add more details about how your application authentication works. Does it uses integrated windows authentication?

Re: Embed Power BI report in web application using Power BI Report Server

Anonymous — Sat, 11 Apr 2020 08:46:43 GMT

Hello Jimmy,

I know this post is old but we have the same requirement now. Where you able to achieve your requirements? It is not just about the embed=true query string. In our case, the user needs to be able to navigate the power bi report server folders and reports. Where you able to read the folders/reports using some kind of api and then filter the ones that the user has access to while hiding the others?

Re: Embed Power BI report in web application using Power BI Report Server

mgn_power — Fri, 25 Aug 2023 05:58:25 GMT

Hey jimmymitra ,

You got solution for the asked question. I have the same requirement now.