Parameterized Custom SQL

[Anonymous]

Hi, 

I have a requirement to pass on parameters into custom sql query to pull data and end user should be able to change these parameter values. 

Ex : I need a date parameter which can be controlled by end user, and this date parameter will be used in sql like below.

select * from table where date = <date_parameter>

once the report is published to power bi service, if end user change value of this date_parameter, entire data in the report should be changed.

Also, I have been searching for custom sql option to azure data bricks but I couldn't find it. I am able to connect to tables on data bricks but not finding an option to write sql on power bi desktop pointing to azure data bricks. Does power bi supports custom sql to azure data bricks ?

Thank you.

[amitchandak]

@Anonymous , refer if this can help

https://channel9.msdn.com/Blogs/MVP-Azure/Pass-parameter-to-SQL-Queries-statement-using-Power-BI

check : https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712