Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Native query on Oracle use TO_TIMESTAMP function for date fields

In Power Query for Oracle DB queries involving fields with the DATE type all filtering through query-folding is using the TO_TIMESTAMP function. As incremental refresh is implemented, we cannot use S...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

 

Is the Native query from View Native Query in Power Query Editor? You apply filter on datetime column with GUI?

 

Regards,
Community Support Team _ Jing

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

Yes the native query is from View Native Query in Power BI, and filter is applied on datetime column.

 

Thanks,

Vishal