The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All
Need some help about this queries in power bi. I have a report (I only have read/view) rights on it and I want to query it via url.
I have create my URL, the report loads but nothing is filtered.
I saw that you need to be careful of spaces in the query and all thoose limitation and as far I can see I got that right. Out of option so looking is there any additional tip I should try.
Here is my table name with its column name and the filter I am trying. I just dont get it why its not filtering.
https://app.powerbi.com/groups/<someprivateurl>?filter=MIM_MART_FACT_DFO.DM_F_DIP_TRANS_POSITION_LOSS_PREVENTION/Locations eq 'GENN'
I dont get it. You mean I should replace the table name underscores ? like this:
MIM_x005f_MART_x005f_FACT_x005f_DFO.DM_x005f_F_x005f_DIP_x005f_TRANS_x005f_POSITION_x005f_LOSS_x005f_PREVENTION
its not working
Maybe it's time to simplify your table name?
not the owner, dont have access to source table. Maybe I'l try to ask.
you need to encode the underscore.
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
I am looking at this article but i dont see encoding for an _ in the table name. I'l search a bit more
_x005f_
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.