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

DIfference between Power BI Embedded and Report Integration with IFrame

Hi,

 

Can someone explain the difference between Power BI Embedded where I can embed the reports in my own web application.

 

And what's the difference if I will do that using Integrate a report into an App.

 

: https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-report/

 

The requirement I have is to share the reports from Power BI with a set of 1000 users based on their roles.

 

Thanks

 

1 ACCEPTED SOLUTION
Memorable Member
Memorable Member

Hi @anmsharma,

 

As my understand, you are mentioning about PBI Embeded (using js/c#) and IFRAME of Public to web feature? Basically, they are same uses that returns iframe to embed. But

 

Iframe from Public to web

  • Public to web: manually
  • Token expiration to view:  none (just remove embed from Manage Embed code panel)
  • None security  - everyone has same permission with data
  • Managed in PBI service
  • Support both of DQ & Import mode of reports
  • Free - No cost

 

Iframe from api of PBI embeded

  • Using code to embed (automatically)
  • Support direct query mode so far
  • Has expiration (default 15-20') and could be extended by c#
  • Permission by RLS (if available) (DAX handling in report layer for database source or user roles in SSAS source) or user group of tenants
  • Could embed tiles separately report
  • Managed in Azure PBI workspace collection by using azure portal, cli command, js and C# code
  • Charge embeded fee by "session"

 

if amount of roles is not large (e.g 10 roles of 1000 users), you could do workaround solution with "Public to web" by clone pbix file to 10 files and set the filter for data in Query Editor, so you have 10 different iframes and using if/else in your app to show them by role of users.

On the other hand, you could implement RLS in PBI Embeded as mentioned above

View solution in original post

3 REPLIES 3
Memorable Member
Memorable Member

Hi @anmsharma,

 

As my understand, you are mentioning about PBI Embeded (using js/c#) and IFRAME of Public to web feature? Basically, they are same uses that returns iframe to embed. But

 

Iframe from Public to web

  • Public to web: manually
  • Token expiration to view:  none (just remove embed from Manage Embed code panel)
  • None security  - everyone has same permission with data
  • Managed in PBI service
  • Support both of DQ & Import mode of reports
  • Free - No cost

 

Iframe from api of PBI embeded

  • Using code to embed (automatically)
  • Support direct query mode so far
  • Has expiration (default 15-20') and could be extended by c#
  • Permission by RLS (if available) (DAX handling in report layer for database source or user roles in SSAS source) or user group of tenants
  • Could embed tiles separately report
  • Managed in Azure PBI workspace collection by using azure portal, cli command, js and C# code
  • Charge embeded fee by "session"

 

if amount of roles is not large (e.g 10 roles of 1000 users), you could do workaround solution with "Public to web" by clone pbix file to 10 files and set the filter for data in Query Editor, so you have 10 different iframes and using if/else in your app to show them by role of users.

On the other hand, you could implement RLS in PBI Embeded as mentioned above

View solution in original post

Hi @tringuyenminh92,

 

Thanks a lot for your detailed explanation.

 

What I understood is that if there's a limitation of cost and less roles are present we can have the https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-report/ using C#.

 

If we want  a solution with proper RLS and all we can go with Power BI Embedded.

 

I have a small question, the report in Public to Web will be embedded in my own application and would be interactive as the normal reports?

 

Thanks again.

Hi @anmsharma,

 

yes, it would be interactive as normal reports that you are viewing in report area in PBI Service. there is one more limitation about iframe size, it's fixed so you could not adjust to full width of your html view (but there is fullscreen mode of report as workaround solution)

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors