Forum Discussion
Can i call Stored Procedure with Direct Query?
-> Import vs Direct Query – So at the moment i am loading the queries into Power BI Desktop by using Import Query rather than Direct Query inturn it stores the data in the cloud, which isn’t security...
I get same error when I try to execute SP in direct query mode.
Incorrect syntac near'EXECUTE.'
Is the a resolution yet?
At present, its best to call a TVF instead - as such, if feasible - parse the SP into a function.
If you're looking to pass parameters into your query (whether that is a function or SP) that is not possible at present.
