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

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.