topic Re: Power BI Url query paramters not working in Report Server

Power BI Url query paramters not working

FlipFlop17 — Fri, 29 Mar 2024 08:36:19 GMT

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'

Re: Power BI Url query paramters not working

lbendlin — Fri, 29 Mar 2024 12:57:26 GMT

you need to encode the underscore.

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

Re: Power BI Url query paramters not working

FlipFlop17 — Fri, 29 Mar 2024 13:02:47 GMT

I am looking at this article but i dont see encoding for an _ in the table name. I'l search a bit more

Re: Power BI Url query paramters not working

lbendlin — Fri, 29 Mar 2024 13:07:32 GMT

_x005f_

Re: Power BI Url query paramters not working

FlipFlop17 — Fri, 29 Mar 2024 13:13:08 GMT

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

Re: Power BI Url query paramters not working

lbendlin — Fri, 29 Mar 2024 13:14:09 GMT

Maybe it's time to simplify your table name?

Re: Power BI Url query paramters not working

FlipFlop17 — Fri, 29 Mar 2024 13:16:23 GMT

not the owner, dont have access to source table. Maybe I'l try to ask.