cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pundiv01 Regular Visitor
Regular Visitor

Filter is not applying in query string in power bi server

Hi,

 

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

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.
 
4 REPLIES 4
Super User
Super User

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

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


pundiv01 Regular Visitor
Regular Visitor

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

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

 

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

pundiv01 Regular Visitor
Regular Visitor

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

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

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

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?