Forum Discussion

DocDri's avatar
DocDri
Helper I
1 year ago
Solved

Filter via Power-BI URL does not work

Hello,   I want to filter a report via URL. That worked well for me with several fields, but with one I have a problem:   The Table name is MMM_GGG: Table000 The field name is: Order Number   ...
Need Help
  • DocDri's avatar
    DocDri
    1 year ago

    I have the solution now. Colon (:) has to be coded with x003a_ and underscore (_) with _x005f_ so the correct url which works is: 
    ?filter=MMM_x005f_GGG_x003a__x0020_Table000/Order_x0020_Number eq '123AB'

grazitti_sapna's avatar
grazitti_sapna
Super User
1 year ago

Hi DocDri 

Can you please try the below syntax:
?filter=MMM_GGG_Table000/Order_x0020_Number eq '123AB'

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!



DocDri's avatar
DocDri
Helper I
1 year ago

Thanks, but that doesn't work.