Forum Discussion

shavish's avatar
shavish
Helper I
1 year ago
Solved

SQL syntax error

Hello all,   Am trying to add data from SQL server through direct query option. When i add data and i am getting following error: Microsoft SQL: Incorrect syntax near the keyword 'DECLARE'. Incorr...
Need Help
Tips and Tricks
  • hnguy71's avatar
    hnguy71
    1 year ago

    Hi shavish 

    Power BI wraps your query statement in another SELECT statement, therefore, you won't be able to use the DECLARE function.

     

    You can try this instead:

    SELECT
CONVERT(varchar(50), Table1.names) As Name,
CONVERT(varchar(50), Table1.id) As ID,

FROM
Table1

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi shavish ,


I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi shavish ,

 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.