Forum Discussion

Pallavi's avatar
Pallavi
Icon for Helper II rankHelper II
8 years ago

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...
Need Help
mehulvt's avatar
mehulvt
Icon for Advocate I rankAdvocate I
8 years ago

Hi,

 

I get this error when I try to execute SP in direct query mode. SP has no parameters.

 

 

Incorrect syntac near keyword EXECUTE. Incorrect syntax near ')'

 

 

 

Does Power BI support SP call in direct query mode?

 

 

Noak's avatar
Noak
Icon for Helper IV rankHelper IV
8 years ago

I have the same problem