Forum Discussion

Lierreyy's avatar
Lierreyy
Advocate I
4 years ago
Solved

Power BI Report URL Query Parameter for Text Field

Hi, I’m trying to get a URL to filter a report with a certain criteria and I’m having a difficult time with it. I know it’s done through query parameters, and I’ve looked through the documentation h...
Need Help
  • Lierreyy's avatar
    Lierreyy
    4 years ago

    Hi v-janeyg-msft,

     

    I figured out the issue!!

     

    I first checked the other items you asked me to check (other reports, making sure the city field is text, etc.) and I couldn’t find any issues with that. Then I thought it might be an issue with my quote (since all the numeric fields that don’t require a quote works). And indeed it was!

     

    I copied 'manager name' directly from the website documentation and it filtered!

     

     

    Then I realized what my issue was! To make it easier to type the URL, I was first typing it in a Microsoft Word document and then coping and pasting the URL in the browser. But what was happening was that Microsoft Word by default changes “straight quotes” to “smart quotes”.

     

     

    Notice how in the former the quote curves around the word while in the latter it’s a straight quote.

     

    After I realized this, I changed it to use straight quotes, so now it works!

     

     

    Thanks so much for your help on this!!! I really appreciate it! 🙂

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, Lierreyy 

 

I tested again on both edge and chrome browsers without any issues. So it shouldn't be a bug.

The problem should be with your report. You can arbitrarily test other reports on your pbi service to see if the text field can be properly filtered.

Secondly, please re-publish the report, or check whether there are RLS and other permission restrictions in the report. Check if your city field type is text. 

What is your data source? Have you updated your desktop version to the latest?

If possible, please share some unsensitive data to help us clarify your scenario.

 

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
 
Best Regards,
Community Support Team _ Janey
Lierreyy's avatar
Lierreyy
Advocate I
4 years ago

Hi v-janeyg-msft,

 

I figured out the issue!!

 

I first checked the other items you asked me to check (other reports, making sure the city field is text, etc.) and I couldn’t find any issues with that. Then I thought it might be an issue with my quote (since all the numeric fields that don’t require a quote works). And indeed it was!

 

I copied 'manager name' directly from the website documentation and it filtered!

 

 

Then I realized what my issue was! To make it easier to type the URL, I was first typing it in a Microsoft Word document and then coping and pasting the URL in the browser. But what was happening was that Microsoft Word by default changes “straight quotes” to “smart quotes”.

 

 

Notice how in the former the quote curves around the word while in the latter it’s a straight quote.

 

After I realized this, I changed it to use straight quotes, so now it works!

 

 

Thanks so much for your help on this!!! I really appreciate it! 🙂