Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |