Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using date variable in Power BI in sql query

user-mt42kFeb 7 2023

What I'm trying to accomplish is building an incremental refresh in Power BI but I'm using a SQL query to pull data from an Oracle database. In my screenshot, I have a my select query as the first step in Power Query and I'm calling the date parameters into my date filter where clause. I can see that the dates are registering in the query (3rd image), but Oracle is still throwing an error about the date format.

Comments
Post Details
Added on Feb 7 2023
1 comment
1,981 views