Forum Discussion

StuartPQY's avatar
StuartPQY
Frequent Visitor
1 year ago
Solved

SQL Script wont run in Power Query

Hello   I have some SQL that runs fine in MS SQL Studio, but will not run in Power Apps (in Excel ver 2402 build 16.0.17328.20550) 64 bit)   The error I get is  DataSource.Error: Microsoft SQL: ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    The fact that the error is coming from the SQL Server means that your steps are correct and the query is getting to the server so the problem is your SQL. 

     

    --Nate

PwerQueryKees's avatar
PwerQueryKees
Icon for Super User rankSuper User
1 year ago

Please share your actual (failing) M code with the SQL statement in it. It is probably to do with quoted text inside quoted text.