Query string on embed code in Power Apps

[Avih]

Hi All,

How can I use contain here instead of eq? no matter how I try it, it's not working.

The eq is working, but no matter how I try it with "contains", it's not working, it's just showing me all of the rows, instead of the filtered rows according to the Textsearchbox.

The embeded code that is working with eq:

"https://app.powerbi.com/embed?dashboardId=......&filter=FACT_Tasks/TaskName  eq '" & Textsearchbox.Text & "' "

Thanks!

[v-venuppu]

Hi @Avih ,

May I ask were you able to post this question over in the Power Apps community.If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu · Accepted solution]

Hi @Avih ,

Thank you for your response!!

Sorry for the delay in Response.

Can you please post the question in Power Apps community as this is Fabric community.

You can use below Power Apps community link to post:

https://community.powerplatform.com/forums/thread/?groupid=b5652dc6-2c99-4e33-8b6f-45be4a896a40

Thank you.

[v-venuppu]

Hi @Avih ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

[Avih]

It didn't work unfortuantly.

[v-venuppu]

Hi @Avih ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response. 

Power BI implementation of OData might not support the "contains" function directly in the query string. However, you can try using the following format:

&filter=contains(FACT_Tasks/TaskName, '" & Textsearchbox.Text & "')

If this approach still doesn't work, you might need to  handle the filtering logic within Power Apps itself before passing the filtered data to Power BI.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Regards,

Rama U.

[lbendlin]

I don't think the Power BI implementation of OData supports "contains"  but you can try it

Consider contains: $filter=contains(CompanyName,'Alfreds')

In your case that would be  

&filter=contains(table/column,'lookupvalue')

Note that your table name has characters that need to be escaped.

[Avih]

Unfortuantly it's still not working.
Is there maybe any other way to overcome this?