Forum Discussion

Kushagra's avatar
Kushagra
Frequent Visitor
3 years ago
Solved

URL Filtering not working

Hi I have tried filtering powerbi report using url filters, but unable to make it filter the published report   {url of report}/ReportSection?filter='Sheet1'/name eq 'Samuel Jack'   Any help is a...
  • OwenAuger's avatar
    OwenAuger
    3 years ago

    Hi Kushagra 

    A couple of suggestions that may help:

    1. Does your table Sheet1 contain the column Sheet1[name]?
      Just checking, since the column used in the visual appears to be name column.
      If it doesn't exist, you could create a name column and set it equal to name column. 
    2. Column names used in URL parameter filters only work if they don't contain spaces.
    3. In my testing, filters will not work if table names are enclosed in single quotes, so remove the single quotes around Sheet1.

    Putting this together, as long as your table Sheet1 contains the column name, this should work:

     

    {url of report}/ReportSection?filter=Sheet1/name eq 'Samuel Jack'

     

     

OwenAuger's avatar
OwenAuger
Super User
3 years ago

Hi Kushagra 

A couple of suggestions that may help:

  1. Does your table Sheet1 contain the column Sheet1[name]?
    Just checking, since the column used in the visual appears to be name column.
    If it doesn't exist, you could create a name column and set it equal to name column. 
  2. Column names used in URL parameter filters only work if they don't contain spaces.
  3. In my testing, filters will not work if table names are enclosed in single quotes, so remove the single quotes around Sheet1.

Putting this together, as long as your table Sheet1 contains the column name, this should work:

 

{url of report}/ReportSection?filter=Sheet1/name eq 'Samuel Jack'

 

 

Kushagra's avatar
Kushagra
Frequent Visitor
3 years ago

Hi Owen, 

I tried using a new report, with correct names of table and columns, but it still wont work. Is this a limitation of PowerBI Pro license for a report that is published?


 

How my data looks has been shared below for reference - 

Visualization view -

 

Dataset - 

 

After publishing, my url to test this filtering is - {url of the report}/ReportSection?filter=Salary/emp eq 'Jack'

 

Yet there is no update on the filter (both with and without filter lock on PowerBI desktop)

 

  • OwenAuger's avatar
    OwenAuger
    Super User
    3 years ago

    Hi again Kushagra 

    That's odd that it's not working at your end. Have you had any success since your last message?

    I have created and published a report essentially identical that in your last post, and the URL filter you posted works as intended. I used an account without a Pro licence and published to My Workspace.

     

    Regards,

    Owen