Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter report with URL query paramaters

I cannot get the newly added feature to filter reports through URL query paramters to work.   I have created a report with a manually entered table with the name Table1. Columns are Column1 and Col...
APIS and Embedding
  • muchinski's avatar
    muchinski
    8 years ago

    Hi Anonymous,

     

    I really dont know if that is the case, but I had some problems with visualizations that were solved after I cleaned the Chrome's browser cache.

     

    Filters here works with Chrome...

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

The issue should be the Column1 data type is number, while it requires field to be string. You can filter via this URL:

http://server/reports/powerbi/TestReport?filter=Table1/Column2  eq 'A'

 

For more infomration, see: 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19727650-pass-filter-in-url-power-bi-report-server

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/

 

Best Regards,
Qiuyun Yu