topic Passing in a Variable via the URL to be included in the query executed in Developer

Passing in a Variable via the URL to be included in the query executed

jbalon — Mon, 21 Mar 2022 16:35:45 GMT

We are trying to run a powerbi dashboard based on data passed in the URL. We have been successful in testing passing in a parameter that would filter the dataset. Our issue using filtering is that what we need to filter, the dataset would be large and ultimately very slow for what we need.

We would love to pass in the data value in the URL and that value be used in the query that would get the data to display.

Any ideas or advice on how we can accomplish this would be greatly appreciated. Thank you.

Re: Passing in a Variable via the URL to be included in the query executed

Anonymous — Thu, 24 Mar 2022 07:42:24 GMT

Hi @jbalon ,

Power BI support you to filter your a report with query string parameters in report url.

Here is an offical blog about how to filter a report using query string parameters in the URL.

For reference:

Filter a report using query string parameters in the URL

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.