topic Re: Filter is not applying in query string in power bi server in Report Server

Filter is not applying in query string in power bi server

Anonymous — Fri, 25 Jan 2019 11:22:27 GMT

Hi,

I have a table and prepared a report in desktop and made a measure which calculate the URL based upon a ID dynamically.

URL = "https://app.powerbi.com/groups/ce347380-637d-4700-838f-f7b00294256c/reports/374c3b7b-18f0-46f6-b5ec-2c97cbb01611/ReportSection?filter=Append1/Append1[SIMPrjReqID] eq '&Append1[SIMPrjReqID]&'"

This URL has [SIMPrjReqID] column as filter. When I publish this and try to see the filter report;It could not show me the filtered report

but only show me the original one which has all the data.in that way the filters are not applying by this URl.

The [SIMPrjReqID] is Text type.

May I seek for help.Please let me know for additional things you want to know about it.

Re: Filter is not applying in query string in power bi server

Greg_Deckler — Fri, 25 Jan 2019 11:43:49 GMT

Can you post your DAX formula? What you posted doesn't look quite correct.

Re: Filter is not applying in query string in power bi server

Anonymous — Fri, 25 Jan 2019 12:24:19 GMT

?filter=Append1/Append1[SIMPrjReqID] eq '&Append1[SIMPrjReqID]&'"

after report I am amending this formula in URL in order to create dynamic measure.

Re: Filter is not applying in query string in power bi server

Anonymous — Fri, 25 Jan 2019 12:43:53 GMT

"https://app.powerbi.com/groups/ce347380-637d-4700-838f-f7b00294256c/reports/374c3b7b-18f0-46f6-b5ec-2c97cbb01611/ReportSection?filter=Append1/Append1[SIMPrjReqID] eq '&Append1[SIMPrjReqID]&'"

this is the complete dax which i am using to create dynamic url (Append1 is table and [SIMPrjReqID] is column name.)

Re: Filter is not applying in query string in power bi server

Anonymous — Thu, 31 Jan 2019 04:35:21 GMT

The calculated URL is fine now but after publishing it is not giving me filter data.Could you please help.

I just went through a blog and when publishing through query string parameter it says that it has a limitation that it doesn't work when it will be published to web..what does it mean?