Forum Discussion
Calling Stored Procedure for Big Query as Power BI Data Source
Hello! I have been struggling to get a Stored Procedure I created in BigQuery to load in as a dataset in PBI. I have created the required ODBC connections, and I am able to run simple direct ...
Yes, you can use stored procedures in Power BI Import mode by entering a native SQL query (e.g., EXEC MyProcedure), but only if the procedure returns a single result set and has no output parameters. For more stability, it's better to use a SQL view instead.
Hi Anonymous ,
I wanted to follow up on our previous suggestions regarding the issue you are facing currently. We would like to hear back from you to ensure we can assist you further. If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.