Power BI ignoring passed parameters in URL

[Anonymous]

I have tried before to pass a parameter to a Power BI report and its URL which I have received from "File", "Embeded". I have added ?filter=Table/Field eq 'Fieldvalue'. Like this https://docs.microsoft.com/en-us/power-bi/service-url-filters 

Well, now I can't get it to work! Has something happened? 

I also saw this simular link: https://community.powerbi.com/t5/Issues/Report-URL-parameters-filtering-not-working-for-embed-links/...

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous, 

Based on my test, if you use the Embed a report in a secure portal or website feature to get the URL, you can pass the filter parameter via $filter=Table/Field eq 'value'. For example, assume the embed URL is 

https://app.powerbi.com/reportEmbed?reportId=7860e7e8-4acf-4e94-a860-1af6d633ad57&autoAuth=true&ctid=cd0b6578-32a4-410b-8f18-0d7f6055ef70&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVzLWVhc3QyLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9

We can pass the filter parameter by modifying URL like below: 

https://app.powerbi.com/reportEmbed?reportId=7860e7e8-4acf-4e94-a860-1af6d633ad57&autoAuth=true&ctid=cd0b6578-32a4-410b-8f18-0d7f6055ef70&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVzLWVhc3QyLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9&$filter=DimSalesTerritory/Group eq 'Asia'

Reference: 

https://docs.microsoft.com/en-us/power-bi/service-embed-secure#filter-report-content-using-url-filters

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @Anonymous, 

It looks like the issue is resolved now, right? If it is, would you please mark a helpful reply as an answer? 😊

Best Regards,
Qiuyun Yu

[Anonymous · Accepted solution]

Thanks alot @v-qiuyu-msft !

This made my day😀

Best Regards

Christofer

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous, 

Based on my test, if you use the Embed a report in a secure portal or website feature to get the URL, you can pass the filter parameter via $filter=Table/Field eq 'value'. For example, assume the embed URL is 

https://app.powerbi.com/reportEmbed?reportId=7860e7e8-4acf-4e94-a860-1af6d633ad57&autoAuth=true&ctid=cd0b6578-32a4-410b-8f18-0d7f6055ef70&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVzLWVhc3QyLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9

We can pass the filter parameter by modifying URL like below: 

https://app.powerbi.com/reportEmbed?reportId=7860e7e8-4acf-4e94-a860-1af6d633ad57&autoAuth=true&ctid=cd0b6578-32a4-410b-8f18-0d7f6055ef70&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVzLWVhc3QyLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9&$filter=DimSalesTerritory/Group eq 'Asia'

Reference: 

https://docs.microsoft.com/en-us/power-bi/service-embed-secure#filter-report-content-using-url-filters

Best Regards,
Qiuyun Yu