Forum Discussion
URL Filter
- 10 years ago
I just tested it on my side and it worked all fine for me. Could you go and check the URL format and try it again?:smileyhappy:
URL = reportURL + ?filter=table/column eq 'value'
Note: The column must be of type string and neither the table name nor the column name can contain spaces.
Regards
Hello,
You can read about it here: http://mmaitre314.github.io/2016/02/13/passing-report-filters-to-power-bi-using-urls.html
Ohh.. This is called passing of a parameters to the Web.contents function in Query editor. It is still supported and This is now more powerful as you can pass the list of values, Query and/or single value to this.
- lcasey10 years ago
Post Prodigy
Yes, Sorry, I didnt explain it correctly, but anyway, this has not been working for a few weeks now. It is actually a service outage and I am surprised more people are not complaining that this is no longer working.
- v-ljerr-msft10 years ago
Microsoft Employee
I just tested it on my side and it worked all fine for me. Could you go and check the URL format and try it again?:smileyhappy:
URL = reportURL + ?filter=table/column eq 'value'
Note: The column must be of type string and neither the table name nor the column name can contain spaces.
Regards
- lcasey10 years ago
Post Prodigy
No It doesnt work, It may be an outage on Our tennant. I opened a case Last week and have had no updates or information from Microsoft.
Here is the URL I use: Workflow = "https://app.powerbi.com/groups/me/reports/39d1cfaa-569f-46fd-9a52-d4188135af23/ReportSection2?Filter=00-workflow/Tagnumber" & "eq" & '00-Kwiktag'[ImageTag]
And here is How it looks when Clicked:
https://app.powerbi.com/groups/me/reports/39d1cfaa-569f-46fd-9a52-d4188135af23/ReportSection2?Filter=00-workflow%2FTagnumber eq 'KT0000039873'