Forum Discussion
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: ...
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
hi StuartPQY
I cannot see FROM clause in your SQL statement but maybe you truncated it in post. If not you can check if your SQL completed.
If everything is ok with SQL code I would advise trying query folding. To test it go for this steps:
1. Add your sql server connection string and select table that you would like to transform,
2. Create conditional colum where you add your logic to align with Case statement you want to get
3. Remove all other columns.