Forum Discussion
Microsoft SQL: Incorrect syntax near the keyword 'exec'. Incorrect syntax near ')'.
I have a SP in Azure SQL Database, the SP runs fine in azure and into the transform (power query) window, but it's unable to load into the data model. It returns back Microsoft SQL: Incorrect syntax ...
Hi Anonymous
Do you import data or use direct-query?
Check the document below to see if you do the right thing.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft
Community Support
Community SupportHi Anonymous
Do you import data or use direct-query?
Check the document below to see if you do the right thing.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
my mistake I must have been using direct query on accident. Works fine today on import