cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sheehrt
Frequent Visitor

Snowflake Connector - Group By Native Query

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?

1 ACCEPTED SOLUTION
Sheehrt
Frequent Visitor

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.

View solution in original post

1 REPLY 1
Sheehrt
Frequent Visitor

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.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.