Forum Discussion

ebjm's avatar
ebjm
Regular Visitor
8 years ago

How to pass a parameter to a MySQL stored procedure from powerBI

Hi - I am using powerBI to connect to a MySQL server. We can connect fine and we can receive data fine - I am calling a stored procedure from powerBI using the following command; CALL my_sp(); My...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yep, you can pass as many fields into the R visual as you need. You can then reference all of them in your SQL code embedded in your R code

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
8 years ago

I am going to try this tonight, does your video detail all the necessary information? Also for the RODBC connector, do we need to download that on SSMS?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    The only difference between my video and your situation is that you will be passing in a Power BI parameter. To do this, you will need to create the parameter and enable load so that you can then pass it into the R Visual. As for RODBC, that's an R package that you will need to install. Other than that, you should be good to go. Feel free to reach out with questions.

     

    Edit: Reading back through your initial post, not sure if you are passing a Power BI parameter. You will be able to pass any column or Power BI parameter using this method.