Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
5 years ago

How to get data from a stored proc in DirectQuery mode

when I apply something like this: exec sp1 in DQ mode I get this incorrect syntax near the keyword 'EXEC'. Incorrect syntax near ')'. Next suggestion was use OpenQuery: Gettin Error while loading ...