As far as I know, currently call Stored Procedure from BigQuery to Power BI could not be supported.
Different with sqlserver database and mysql database, although Googlebig query database has import and direct query these two connection modes, it does not have the query parameter in the connection function so it could not call the procedure to power bi.
In other words, currently Googlebig query database could not support a native query in power bi so that it could not call the procedure.
In addition, you can sumbit a new idea here about this issue to help us improve power bi.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Hopes it could help.
Best Regards, Community Support Team _ Yingjie Li If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.