Forum Discussion

Marico's avatar
Marico
Helper IV
4 years ago
Solved

Urgent! - 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:

 

 

 

 

when I try to run the SQL in snowflake, the query runs perfectly fine.

 

Thanks for the support.

Need Help
  • Marico's avatar
    Marico
    4 years ago

    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.

5 Replies

  • jeffshieldsdev's avatar
    jeffshieldsdev
    Solution Sage
    4 years ago

    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's avatar
      Marico
      Helper IV
      4 years ago

      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.