Forum Discussion
Power BI Url query paramters not working
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'
6 Replies
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_
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.
