How to embed a public report using filters?

Question

I would like to embed a report in my website, using filters and i want this report to be public

I saw that you can use the "Publish to web" option to do that but you can't use filters (I read that but i'm not sure)

and with the new "Embed" option you can filter but you need to have a account to see the report.

Is there a way to do both filtering and enable access to anyone on the internet ?

Thanks

Answer 1

When you use "Publish to web" the filtering pane will not be visible, but you can always add slicers to your report, which will allow your visitors to filter the data.

The proper way to do this is to actually embed the report into your site. You can see it in action in Power BI Embedded Playground. When embedding, there are two scenarios - "user owns data", in which each visitor needs Power BI Pro account to see the report, and "app owns data", in which your application uses one Power BI Pro account to authenticate itself, but your users don't need to have Power BI accounts at all. In your case you need the later one.

Simply download Microsoft's sample application and configure it. You need to register Azure AD application to be used in your app. Then your app will authenticate itself and use Power BI REST API to get report's embedUrl and use it with Power BI JavaScript client to embed it in an empty <div> in a web page.