The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a report published to an app in the service and I'm reviewing the many ways in which I can pass variables from Salesforce into the filter criteria for the Power BI report through the URL in visualforce pages. The one issue I have not been able to resolve is generating a URL that will work similar to ( where X like '%somecriteria%' ) would in a SQL query.
Power BI desktop has the capability of selecting "contains" via advanced filtering options, but the documentation doesnt reveal much about how the URL filtering would work to generate that kind of filter. The eq and IN operators didn't seem to work with any kind of wildcards.
Any thoughts?
Same situation for me - Have you found a solution or workarround? Thanks
Were you able to find a solution?
I have the same issue, cannot get a wat to filter a report through URL with contains condition.
As far as I can tell, there is no solution.
I'm looking for a solution to this issue as well.
@Anonymous
Solved: How to use or operator in URL filter - Microsoft Power BI Community
Please check
Regards,
Ritesh
Thanks - but the documentation doesn't cover my use case. Documentation outlines scenarios where parameter values are exact matches. I need something that functions like a where clause with wildcards.
For instance - I need to find value X in all rows that contain X... so the filter woud find rows that have
X
0X0
asdfXf
erc...