Snowflake Connector - Group By Native Query

[Anonymous]

Hi all,

I'm attempting to connect to a snowflake database and use the SQL statement option under advance options to pull back some specific data, when I do I'm receiving the error "Native queries aren't supported by this value."   The SQL I'm attempting to use runs fine against the snowflake database directly but through power BI I'm having issues.

After a bit of experimentation I've narrowed the issue down to the group by clause statement at the end of my SQL, without the group by I can pull data back however there is simply too much data to pull into power BI thus why I'm using a group by.  does anyone know a way around this?

[Anonymous · Accepted solution]

I resolved my issue, it was not the group by but instead the semi-colon that snowflake had added to the end of the statement which power bi did not agree with.  After removing the semi-colon the sql worked as expected.