Forum Discussion

Kir123's avatar
Kir123
New Member
3 years ago

Need help to pass Google sheet as input parameter to stored procedure via query editor

Hello Community,

 

I am trying to pass a google sheet as input parameter to a stored procedure which is being executed through query editor. 

I have created a stored procedure which accepts the input parameter as a TVP (Table valued parameter).

I want to pass the google sheet as a TVP to the stored procedure to load data to the physical table in database, but i am unable to pass the google sheet as input parameter to the stored procedure in PowerBI. 

Could anyone please help on this!

 

Attached Google Drive folder (URL: https://drive.google.com/drive/folders/1Mzv0g58wv_JqS7uy3zL7cFd9RSFMn-Ie?usp=sharing ) contains -

  • input google sheet file,
  • SQL script for creating the table, table type and stored procedure,
  • Power BI file

Note: I understand this can be done using an ETL tool like SSIS but we have a limitation to use only stored procedure.

 

Thanks in advance.

No RepliesBe the first to reply