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 check and see if you had a chance to review our previous message or Please let me know if everything is sorted or if you need any further assistance.If it helps,consider accepting it as solution.
Thank you.