@daxesh wrote:
Hello,
Too much confusions regarding way of embedding power BI report with my web application.
What my requirement is to embed power bi report in my web application and embedded report should be filter by web application's filter.
I found two was to embed report in web application as below
1.Using Power BI API
2.Power BI Embedded.
(It would be great if anyone can make me understand the cost involve in above options)
Now after embedding in any of the above ways i want a custom filters of application to intract with report.For that i found PowerBI-Javascript API.
https://github.com/Microsoft/PowerBI-JavaScript/wiki
I am not sure will above Power BI - Javascript will work with option 1 or 2.
It will be great if anyone can focuses on this.
Thanks in advance.
@daxesh
Regarding cost, license is required in Option 1. Every user to view the report need a license. Check Power BI pricing.
As to option 2 Power BI Embedded, there's no license involved, the cost depends on how often your view the reports. Check Power BI Embedded Pricing. So you would evaluate the cost and compare $9.99/month(for pro license)*users to $5/100 Sessions to make a proper purchase plan in your case.
Javascript API works for both. Regarding custom filters, you can check this live demo Custom filter pane.
By the way, at this moment, there's no refresh feature for Power BI Embedded and the direct query mode only supports azure sql database/datawarehouse. To "refresh" the reports using other data sources, you would have to refresh the pbix in Power BI desktop and re-import the report in Power BI Embedded.
