How to create an filtered and embedded link

Thomas_Eu · ‎08-13-2019

Dear all,

I want to create an filtered and embedded link.

I can create a filtered link (see Filtered) from my report (see PureLink), but this link opens the report in the Power BI framework. But I want to embedd the report.

I can also embedded the complete report (see Embedded), but than I lose the filter.

I have already tried to follow the instroctions here (see Own-Test), but then I get the message, that I do not have the rights to view the report (but I have).

Can anyone help with the correct syntax?

PureLink: xxxxs://app.powerbi.com/groups/0fbd9b78-1b46-431c-80c6-459da90c0008/reports/397a9665-1e6e-42f8-8312-2be45d9e04f1/ReportSection65b0493b646d23eb40e6

Filtered: xxxxs://app.powerbi.com/groups/0fbd9b78-1b46-431c-80c6-459da90c0008/reports/397a9665-1e6e-42f8-8312-2be45d9e04f1/ReportSection?filter=View/Project eq 'Project1'

Embedded: xxxxs://app.powerbi.com/reportEmbed?reportId=397a9665-1e6e-42f8-8312-2be45d9e04f1&autoAuth=true&ctid=0e17f90f-88a3-4f93-a5d7-cc847cff307e&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLW5vcnRoLWV1cm9wZS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCJ9

Own-Test: xxxxs://app.powerbi.com/reportEmbed?reportId=397a9665-1e6e-42f8-8312-2be45d9e04f1?filter=View/Project eq 'Project1'&autoAuth=true&ctid=0e17f90f-88a3-4f93-a5d7-cc847cff307e&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLW5vcnRoLWV1cm9wZS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCJ9

Jayendran · ‎08-14-2019

Hi @Thomas_Eu

Basically you need to use the PBI Embeed approach (App owns data) using the PBI javascript to create the filters

See this existing thread

Do some demo here

Thomas_Eu · ‎08-14-2019

Hmmmmm, look like it is not possible right now with an "easy" solution (I am not able to write javascript).

Tried a workaround, with publishing the report in an app and to hide it in the navigation, but did not work either (a report in an app can be filtered, but will not open, if the navigation is hidden).

I opend an poll, to integrate this function: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38379445-allow-filters-in-the-url...