Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Passing Parameter for a PowerBI Report

Created Parameter as VisitByID and set list of values from query for that Prameter. Using these steps Created Parameter and filtered with Main Query. i published my report and checked, Its...
Need Help
  • TomMartens's avatar
    TomMartens
    3 years ago

    Hey Anonymous ,

     

    Not sure if this does the trick, but when looking closely at the URL of the failing embedded scenario, I spot two question marks.


    Basically, an URL is pointing to a site, but sometimes you can pass parameters and parameter values to the "endpoint" (the website). The website (the endpoint) is processing the parameter(s)/parameter value(s) before returning the result. Sometimes it looks like the website simply opens, most of the it does, but sometimes a lot has happened in the background due to parameter/parameter values.

    The structure of the URL looks like this
    base url

    parameter(s) section
    The base url and the parameter section are separated by a questionmark. For the sake of readibility I combined a parameter and its parameter value by an underscore. An url with a single parameter will look similar to the next line:

     

    baseurl?parameter_parametervalue

    When working with embedded scenarios the base url is:

    https://app.powerbi.com/reportEmbed
    the first parameter is reportid this makes it
    https://app.powerbi.com/reportEmbed?reportId=d609fc77-f7af-4153-9796-7e8bcca44f15

    If you look closely the next parameter is autoAuth, different parameters are separated by &, the url will then look like the next example:

    baseurl?parameter1_parameter1value&parameter2_parameter2value
     
    Be aware that multiple parameters is not the same as passing multiple columns to filter a report. No matter the number of columns there is only one parameter filter.

    I think replacing the questionmark (?) right in front of the parameter filter with the & will do the trick.
     
    Hopefully, this helps to tackle your challenge.
     
    Regards,
    Tom
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
3 years ago

Hey Anonymous ,

 

from the screenshot, it looks like you are defining a parameter inside Power Query, but from the question, you want to call a report with a "predefined" filter. This article is explaining how this can be achieved: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters?WT.mc_id=DP-MVP-5003068

 

A parameter in Power Query is not the same as an url filter. If the article from above is not helping to tackle your challenge, you have to provide more information about the underlying use case.

 

Regards,

Tom