Public web with filter parameter

[Anonymous]

Within a public website we have several reports with power BI. We want to establish a complete report translation solution and for this we have applied a filter to select the corresponding language, the whole report changes according to the filter correctly. We already know that parameters can only be defined in embedded report links and not in public links. Even so, we have seen that there are solutions based on the Azure PowerBI embedded API and we want to know how they work and what costs they may have associated outside of our current contract. Also if there is any other solution in such a way that we can continue sharing the reports through the public web and taking into account the corresponding language filter.

[ibarrau · Accepted solution]

Hi. The only way to share to public and filter is using Capacity. A Power Bi Embedded licence would be the best to start. Embedded is a capacity licence that will let you adapt power bi reports to web app in many ways with a lot of settings. You can hide/show filter pane, use RLS, filter from the web with a button the report, etc.

You can check pricing right here: https://azure.microsoft.com/en-us/pricing/details/power-bi-embedded/

If you want to know more theory you can check this: https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-analytics-power-bi

Finally there are nice examples of code to understand what you can do and how to do it: https://playground.powerbi.com/en-us/

I hope that helps,