Forum Discussion

WCONGRAVE's avatar
WCONGRAVE
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Url Parameters dont filter when report published to app

Hi   I have published a report to my workspace and the URL filter works fine     https://app.powerbi.com/groups/me/reports/[REPORTID]/ReportSection?filter=PubInfo%252FPHC%20eq%20%273408%27   h...
  • WCONGRAVE's avatar
    WCONGRAVE
    9 years ago

    Morning

     

    I've resolved the issue. The filter doesnt work with the link to the group workspace.

     

    BUT if you retrieve the report from the "View Content List" on your app, then its a different URL, and the filter parameter works on this one!

     

    Can I give myself Kudos? Man Happy

  • WCONGRAVE's avatar
    WCONGRAVE
    8 years ago

    hi

     

    Yep, got this working. Steps I followed are below

     

    1. Open app

    2. Go to "View Content List" (top right - icon looks like bullet points)

    3. Click on the report you want to filter. This will take you to the app published version of the report, and the URL should include the words APPS in the string (see below)

     https://app.powerbi.com/groups/me/apps/xxxx-xxxx-xxxxx-xxxxx/reports/xxxx-xxxx-xxxxx-xxxxx/ReportSection

     

    as opposed to the workspace version which wont have the app reference

    https://app.powerbi.com/groups/xxxx-xxxx-xxxxx-xxxxx//xxxx-xxxx-xxxxx-xxxxx/ReportSection

     

    4. You can then add your URL parameters to this new URL as per below

     https://app.powerbi.com/groups/me/apps/xxxx-xxxx-xxxxx-xxxxx/reports/xxxx-xxxx-xxxxx-xxxxx/ReportSection?filter=TableName/FieldName eq '12345' 

     

     

    Hope this helps

    Warwick