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 ,
Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.