cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Galat198
Helper III
Helper III

Call Stored Procedure from BigQuery

Hi,
It is possible to call Stored Procedure from BigQuery to Power BI?


Like:

call `project.dataset.test_p` (130, 200)
1 REPLY 1
v-yingjl
Community Support
Community Support

Hi @Galat198 ,

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.

googlebigquery.pngsql.pngmysql.png

my1.pngsql1.png

 

In other words, currently Googlebig query database could not support a native query in power bi so that it could not call the procedure.

Please refer this document about Connectors that support native database queries in power bi desktop currently.

 

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.

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors