Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI,
What is the right syntax to load table with"
where table.date > 2013?
Year is after 2013 - I got many kind of error.
Many thanks.
Solved! Go to Solution.
@nirrobi you can look here to determine the cause
http://www.techonthenet.com/oracle/errors/ora00911.php
@nirrobi what is the datatype of the date column?
Something like this may work, but without the schema of the table no one can directly help you
select <column1>, <column2>, etc
from table
where date > '2013-1-1'
Hi,
the data type is:
2015-10-04 00:00:00
I succeed in excel query to filter by date but its look like:
DATE>{ts '2015-10-04 00:00:00'}
when I paste it in power bi I get the error:
Oracle: ORA-00911
Any idea?
many thanks.
Nir
@nirrobi you can look here to determine the cause
http://www.techonthenet.com/oracle/errors/ora00911.php
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |