Oracle SP calling with date parameter in Power BI Desktop.

Hi sahubibhuti45 

In Power BI Desktop you can call an Oracle Stored Procedure with a date parameter using a query like this:

EXEC MyPackage.MyProcedure(TO_DATE('2024-01-01','YYYY-MM-DD'))

Steps:

1. Get Data >> Oracle database.

2. In the SQL statement box, paste your EXEC command.

3. To make the date dynamic, create a Power Query parameter (Manage Parameters >> type Date) and replace the hardcoded date with:

EXEC MyPackage.MyProcedure(TO_DATE(' " & Date.ToText(ParameterDate,"yyyy-MM-dd") & " ','YYYY-MM-DD'))

This way you can pass a date parameter from Power BI into your Oracle SP.

https://learn.microsoft.com/en-in/power-query/power-query-query-parameters