Filter Power BI Dashbord by URL Parameter

0
votes

I need to filter data in a public dashboard publish-to-web Power BI like a example.

Spain

France

I can filter in a non-public url dashboard but I cant filter by Parameter in publish-to-web Power BI.

It is mean, I can build a Dashboard with data from a table with

| Column A | Column B |

| Field A0 | Field B0 |

| Field A1 | Field B1 |

Then, I publish-to-web with Power BI service, this service generate a url like https://app.powerbi.com/view?r=eyJrIjoiN2EzOTM0Y2YtODVlZS00NGFjLTk5MTEtOGM4ZGY2NGZhYTNkIiwidCI6IjhmYmFhNWJmLTJlY2MtNGRjOC1iNTZiLThmOTJlMzA3ZjA3NiIsImMiOjR9 It is just a example

I need to filter by Field A0 or Field A1 the data by url parameter like https://app.powerbi.com/view?r=eyJrIjoiN2EzOTM0Y2YtODVlZS00NGFjLTk5MTEtOGM4ZGY2NGZhYTNkIiwidCI6IjhmYmFhNWJmLTJlY2MtNGRjOC1iNTZiLThmOTJlMzA3ZjA3NiIsImMiOjR9&Column A=Field A0

and the dashboard just show data related with Field A0 and hide all data from other fields.

pd: sorry my english is very bad

1
powerbipowerbuilderpowerbi-embeddedpowerbi-datasourcepower-bi-report-server

1 Answers

1
votes

URL filters are not supported with Publish to web reports:

URL filters are supported in some embedding scenarios and not in others.

  • Embedding a report in a secure portal or website is supported.
  • URL filters are supported in Power BI Embedded. See Power BI Embedded advanced URL filtering capabilities for details.
  • Query string filtering doesn't work with Publish to web or Export to PDF.
  • Embed with report web part in SharePoint Online doesn't support URL filters.
  • Teams doesn't allow specifying a URL.

If you want to use Publish to web, you must add the filtering in the report itself - either by report/page/visual level filter, or a slicer, or to filter the data. The other option is to embed the report in a web application and use the full filtering capabilities of the API.