cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver II
Resolver II

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

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)

View solution in original post

10 REPLIES 10
Highlighted
Microsoft
Microsoft

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

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

Highlighted
Helper I
Helper I

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

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

 

 

Highlighted
Resolver II
Resolver II

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

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 😉

 

Highlighted
Helper I
Helper I

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

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

Highlighted
Resolver II
Resolver II

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


@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.




 

Highlighted
Helper I
Helper I

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

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

Highlighted
Resolver II
Resolver II

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

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)

View solution in original post

Highlighted
Helper II
Helper II

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

got it working in our environment

 

append

?rs:embed=true

 

BOOM!

Highlighted
Resolver II
Resolver II

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

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

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors