Passing parameter to sql from dropdown list in powerBI (Very interesting and challenging)

It turns out that this is actually possible in Power BI. I've created a walkthrough video on how to do this here.

The basic gist is to add an R visual that takes in your slicer selection as its value. There is an R package called RODBC that can run SQL code against your database. You can then pass your slicer value into the SQl query using some string interpolation or the "paste" function. Let me know how this works for you.

Thanks,

Parker