Filter connection string using parameter containing a value from querystring

[Maria_Buzaglo]

Hi,

How can I connect to an SQL Server database and, in the Advanced Options SQL Statement, filter the connection string with a parameter. 

I mean something in the advanced option like:

"select * from product where product_name = xxxxxx"

And this xxxxxx is a parameter that cames from a querystring.

So, according with the value of the parameter, the connection between the Power BI and SQL will just get the data filtered by that parameter. And this will be automatically and dynamic (everytime parameter automatically change, the data that cames from the connection also change).

Is it possible? If it is possible, how can I do it?

Thanks,

Maria Buzaglo

[v-xulin-mstf · Accepted solution]

Hi @Maria_Buzaglo

You can edit in the advanced options to filter with parameters:

You can try use LEFT JOIN to meet your need, you need two tables in SQL to filter parameters.

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;

You can refer this.

Best Regards,

Link

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