Forum Discussion
DIfference between Power BI Embedded and Report Integration with IFrame
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
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
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)