Forum Discussion
URL Filter Parameter Not Working
Hi Anonymous ,
How did you get the report URL? The highlighted URL looks unmatched with the original one. Please refer to this document.
Best regards,
Yuliana Gu
- Hi Yuliana,Thank you for responding!I copied the report URL from my Workspace and placed it in the following measure:Then, I used the following formula to calculate the report filter:Subproject Filter =Var SubprojectURL = [Subproject URL]RETURNIF(AND(ISFILTERED('ViewProjects'[Project Name]),NOT(ISBLANK(SELECTEDVALUE('ViewProjects'[Project Name])))),// THENSubprojectURL &"?filter=" &"ViewProjects/Project_x0020_Name" &" eq " &"'" &SELECTEDVALUE('ViewProjects'[Project Name]) &"'",// ELSESubprojectURL)I then placed the measure "Subreport Filter" in a table.Please let me know if you see anything wrong in my formulas.Thank you!Regards,Carlos Tortoledo
Hi Anonymous ,
Please set the data category for measure [Subproject Filter] to "Web URL". Besides, please copy the report URL appended with query string parameter into web address to check if it works, similar to below, replace 'xxxx' with a specific project name.
?filter=ViewProjects/Project_x0020_Name eq 'xxxx'Best regards,Yuliana GuHi Yuliana,
I tried the URL you provided with value I added (https://app.powerbigov.us/groups/me/reports/060345ea-c60a-4a0a-9a7c-9787a46e00dc/ReportSection7e2296e1fd4d6a26ab92?ctid=551608f9-48f3-4871-808a-a969ec5cf48a?filter=ViewProjects/Project_x0020_Name eq '72nd Street Park & Parking Structure'), but still not working. I get the same login error.
I also checked the measure [Subproject Filter], and it is indeed categorized as "Web URL".
At this point I am thinking it must be an internal network (on my end) access issue that I need to address with the support staff.
Thank you for all your help!
Regards,
Carlos Tortoledo
Yuliana,
When I click on the report URL that I calculate, Power BI converts the link into "https://login.microsoftonline/55..."
Not sure why it does that.
When I do not select any values in my report (no Project Name selected), my formula returns the report URL without any filter, in which case the link works fine. Only when I select a value, the report filter does not work.
Thank you.
Carlos Tortoledo