Forum Discussion
Marico
Helper IV
Helper IVUrgent! - Power BI Native Query
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...
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.
jeffshieldsdev
Solution Sage
Solution SageBe 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]).
MaricoHelper IV
Helper IVThanks 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.