Parameter in Query String for Client Wise Report

[Anonymous]

Hi All,

I create a report in Power BI and I need to pass parameters through query string for getting data for all my users. But when I pass parameter in URL I do not get for particular organization report, I got organization list.

This is report URL:- https://app.powerbi.com/view?r=eyJrIjoiYWNmMDlkNjItNmFiMy00ZDBkLWEyZmItMDI2ZWQwZjA3NjAxIiwidCI6ImUxZ...

and with the search parameter, I pass this way in the query string.

https://app.powerbi.com/view?r=eyJrIjoiYWNmMDlkNjItNmFiMy00ZDBkLWEyZmItMDI2ZWQwZjA3NjAxIiwidCI6ImUxZ... eq 'bcit'.

Also, check the attached screenshot for the same.

[v-jingzhang]

Hi @Anonymous 

In your screenshot, the table is called UserSignins. But in your URL, it is filter=GetSignInStats/client_id eq 'bcit'

I guess maybe you didn't refer to the correct table so it couldn't find the column in it. Try

filter=UserSignins/client_id eq 'bcit'

For more info, please read Filter a report using query string parameters in the URL - Power BI | Microsoft Docs

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.