Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Parameter in Query String for Client Wise Report

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=eyJrIjoiYWNmMDlkNjItNmFiMy00ZDBkLWEyZmItMDI2ZWQwZjA3NjAxIiwidCI6ImUxZDBiOTkzLWYwYzYtNGJiOC05MjIyLWUxZDk2YjdkOWU5MCJ9&pageName=ReportSection140e9ef9ed136705a7ac

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

https://app.powerbi.com/view?r=eyJrIjoiYWNmMDlkNjItNmFiMy00ZDBkLWEyZmItMDI2ZWQwZjA3NjAxIiwidCI6ImUxZDBiOTkzLWYwYzYtNGJiOC05MjIyLWUxZDk2YjdkOWU5MCJ9&pageName=ReportSection140e9ef9ed136705a7ac?filter=GetSignInStats/client_id eq 'bcit'.

Also, check the attached screenshot for the same.


 



1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    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.