Forum Discussion

gfross's avatar
gfross
Helper I
4 years ago
Solved

Power BI Report Builder Cannot Execute MySQL Stored Procedure

I'm trying to call a stored procedure from MySQL via an System DSN/ODBC Connection (MySQL ODBC 8.0 ANSI Driver) and I'm getting error 'ERROR [42000] [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.27]You have...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi gfross ,

     

    Please use "?" to pass procedure parameters.

    MySQL Stored Procedure Call from SSRS through ODBC 


    Take SQL Server as an example.

    • Use the ODBC connector.

     

    • Call the stored procedure.
    exec ProductCategory ?

    • Result.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

gfross's avatar
gfross
Helper I
4 years ago

I realized that I needed to select a query type of Text and not Stored Procedure. I guess MySQL stored procedures don't like the Stored Procedure type.