Forum Discussion
Pallavi
8 years agoHelper II
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...
Anonymous
2 years agoNot applicable
Hello, I am using SQL SERVER, I dont know if you have something in Oracle. You need to search if you can exec a procedure using a select with Oracle.
sravanpesari
2 years agoFrequent Visitor
Hi, Yes it works in SQL Server with inbuilt function OPENROWSET. But couldn't find the equivalent feature in Oracle, Can anyone impleneted this please provide the steps.