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,
I am getting following error on running a SQL through native query in power query. In power query editor there is no syntax error, however upon loading the data it gives below mentioned error:
when I try to run the SQL in snowflake, the query runs perfectly fine.
Thanks for the support.
Solved! Go to Solution.
Thanks for your inputs. The points you mentioned were alright in the query.
The was in the SQL query syntax (quotes) which were not accepted in power query.
Be sure you're not using a terminating semi-colon in your SQL statement, and are using fully qualified table/view names ([DATABASE].[SCHEMA].[TABLE/VIEW]).
Thanks for your inputs. The points you mentioned were alright in the query.
The was in the SQL query syntax (quotes) which were not accepted in power query.
Use this thread to get your answer !
Proud to be a Super User!
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |