Forum Discussion
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.