Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

URL Filter Parameter Not Working

Hi,

I am having an issue passing parameters in a report URL. I am following the documented format:  URL?filter Table/ColumnName eq 'value' but I get error 404 (see image below). The report works without passing a parameter.

 

I am using the following parameters:

Table Name = ViewProjects

Column Name = Project Name

Value = 'Bay Walk 10th to 12th Street - Marina'

 

Please let me know what I am doing wrong. 

 

Thank you!

 

Need Help

5 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      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]

      RETURN
          IF(AND(
                  ISFILTERED('ViewProjects'[Project Name]),
                  NOT(ISBLANK(SELECTEDVALUE('ViewProjects'[Project Name])))
              ),
              // THEN
                  SubprojectURL &
                  "?filter=" &
                  "ViewProjects/Project_x0020_Name" &
                  " eq " &
                  "'" &
                  SELECTEDVALUE('ViewProjects'[Project Name]) &
                  "'"
                  ,
              // ELSE
                  SubprojectURL
          )
       
      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
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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