Calling Snowflake Stored Procedure from inside Microsoft Excel gets data for preview but doesn't load rows into spreadsheet

Question

I have a Snowflake Stored Procedure that performs a simple Selection and Update on <100 rows. It then returns the selected rows as a new table. I have an ODBC connection to Snowflake that I am then using to call this Stored Procedure from inside a new Excel workbook. This query looks like this:

When I get a preview of this data, it all shows up like this. There are more columns, but I wanted to highlight that all 16 expected rows show up:

The data shows up as expected, and is also updated in Snowflake so it seems like the Stored Procedure is working as expected and running both the selection and the update. However, when I click 'Close & Load', the data isn't actually inserted into the spreadsheet, and it also leaves it as '0 rows loaded'

It then puts the correct Header into the first row, with no data under it.

It seems to me that there is some issue loading the data into the sheet, but I can't figure out why this might be?

Answer 1

Hi @Wiltzius, Nate

I suggest you post this issue to Power BI forum:

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---