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.
mh2587
Super User
Super UserYes, 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.
Thank you!
At the moment, I converted the SQL query to use tables instead of temp tables, then I use a query in Power BI to pull from there. I'm hoping to convert that to a view instead.
Thank you all for your timely feedback!