Passing Parameter for a PowerBI Report

[Sabareeshwari]

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 working fine .  if i try to pass Parameters in Report URL , it shows only default records which i give current value in parameters, Instead of the value i passed in report URL.

I passed Parameter like the below for Report Url ,

URL - https://app.powerbi.com/groups/me/reports/ReportID?filter=SampleTableName/SampleColumnName eq '29'

[Sabareeshwari]

Hi @TomMartens  It's Working fine, Thank you so much for your help.

Can we able to use this Method without asking SignIn option? When User try to Access the report from our web Application , it should show the powerBI Report without asking SignIn .

Please Suggest any solutions for the above requirement.

[TomMartens · Accepted solution]

Hey @Sabareeshwari ,

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]

Hey @Sabareeshwari ,

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-500...

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

[Sabareeshwari]

Hi @TomMartens  ,

 I have changed and checked the filtering based on the above link, It's Working Fine.

 Working URL - https://app.powerbi.com/groups/me/reports/d609fc77-f7af-4153-9796-7e8bcca44f15/ReportSection?filter=... eq 171

 I take a URL from File > Embed Report > Website or Portal and try to pass the filter as mentioned in the link.

URL - https://app.powerbi.com/reportEmbed?reportId=d609fc77-f7af-4153-9796-7e8bcca44f15&autoAuth=true&ctid... eq 171

When i tried the above URL  - SignIn Page Displays , after i click the signin it shows error. Can you Please guide me to rectify this issue.

Error -

This login.microsoftonline.com page can’t be found

No webpage was found for the web address: https://login.microsoftonline.com/a3c84cc4-27a9-418a-9299-b257b05a1beb?filter=PastorActivity/visit_u...

HTTP ERROR 404