topic Re: How to create an filtered and embedded link in Developer

How to create an filtered and embedded link

Thomas_Eu — Tue, 13 Aug 2019 12:55:27 GMT

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

Re: How to create an filtered and embedded link

Thomas_Eu — Wed, 14 Aug 2019 06:35:37 GMT

Has no one ever created a filtered and embedded link?

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

Re: How to create an filtered and embedded link

Jayendran — Thu, 15 Aug 2019 06:16:41 GMT

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

Re: How to create an filtered and embedded link

Thomas_Eu — Thu, 15 Aug 2019 06:30:23 GMT

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-for-an-embedded-report

Re: How to create an filtered and embedded link

Jayendran — Thu, 15 Aug 2019 06:33:19 GMT

Hi @Thomas_Eu

Cool that you have submitted your idea !

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