Forum Discussion
Creating a dynamic filter for URL to PowerBI data (from Power Apps Portal)
Dear Power BI Fellows.
I have a serious problem. I cannot seem to create filter to produce a Power BI report dynamically.
I have a report in Power BI that is represented as https://myReportURL/ --> I want to return results only based on a dynamic value (actually, to be precise, the user ID).
So here's what I have:
https://myReportURL?filter=myTable/myColumnName eq {{ user.fullname}} " % }
the result of user.fullname is in fact a result in MyColumn column.
Its not being accepted. WHy is that?
How on earth do I send this URL a variable? I understand that this variable must be a String, and it is.. The full user name is always a String.
Its not working at all. I've scoured all Microsoft pages - Microsoft only seem to talk about how to send static Strings to the URLs.
I'm really desperate right now.
Thanks for pointers or advice. I'd have thought with Liquid this ought to be a straight forward task.
I've tried even creating a variable and assigning the URL filter a variable - the same : it doesn't work... it only works when I actually specify the string outright i.e. eq 'John Smith'
Thanks
2 Replies
- lbendlinSuper User
Keep in mind that spaces and other special characters need to be escaped correctly for the filter to be accepted.
Also keep in mind that URL filters just change the default, they do not prevent the user from clearing the filter.
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
- AnonymousNot applicable
Hi,
I had a similar problem. From another site I found out that URL filtering does not work with reports that have default values on filters. I tested that and it really was so: when I removed filters from filter panel, filtering with
?filter=... started to work. You can have filters on filter pane but the default values should be set to show all values. Or maybe as the reply above posts: if there are filters on the report, you should set the same filters also to URL filter's filtering rule to change or reset the existing filters.