How to create an filtered and embedded link

[Thomas_Eu]

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]

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]

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...

[Jayendran]

Hi @Thomas_Eu 

Cool that you have submitted your idea !

If my replay helps you please mark it as answer/ give some kudos !

[Thomas_Eu]

Has no one ever created a filtered and embedded link?

Could not imagine, that I am the first one looking for such a possibility...