Forum Discussion

Pallavi's avatar
Pallavi
Helper 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
sravanpesari's avatar
sravanpesari
Frequent Visitor
2 years ago

I have tried this with Oracle stored procedure but it didn't work, can you please give me the steps how to achieve this with Oracle stored procedure.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    sravanpesari
    Frequent Visitor
    2 years ago

    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.