Forum Discussion

wsdcawefwqrevfq's avatar
3 years ago
Solved

Yet Another URL Filter not Working Question

There are many posts about how to filter a PBi report URL and wondering why it "doesn't work".

 

I find myself in the same situiation despite taking advantage of the wisdom in the several posts and responses.

To Wit:

1. The table name and column cannot contain spaces or special characters

2. The table name and column name are case sensitive

3. The search value must be in single quotes

4. The column must be of type text

5. Use ?filter=Table/Column eq 'value'

 

Some unclear things in the documentation:

Some examples have different treatment of the end of the URL:

URL/?filter...

URL?filter...

 

Also the documentation shows:

URL/Reportsection?filter...    Is that just part of the particular report URL or is it a significant component of the search parameter spec?

 

As for my URL that does not work:

 //app.powerbi.com/groups/xxxxxx/reports/xxxxx/ReportSection?ctid=xxxxx&experience=power-bi?filter=Employees/COMPANYID eq 'SSI'   

 

Case confirmed, No spaces, Single Quotes, COMPANYID is of type Text

 

 

Not sure what that "Experience= Power_bi" is.

 

Please Wax Poetic!

 

  • GilbertQ's avatar
    GilbertQ
    3 years ago

    Hi wsdcawefwqrevfq

    What happens if you remove the ctid and Power BI experience and start your URL filter directly after the report section?

5 Replies