Urgent! - Power BI Native Query

[Marico]

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.

[jeffshieldsdev]

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]).

[Marico · Accepted 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.

[Marico]

@amitchandak @lbendlin @Greg_Deckler Can you help with this please?

[VijayP]

@Marico 

Use this thread to get your answer !

[Marico]

@VijayP Can you share the thread link again pls?