cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirrobi
Helper V
Helper V

Get data using sql statement

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.

1 ACCEPTED SOLUTION

@nirrobi you can look here to determine the cause

http://www.techonthenet.com/oracle/errors/ora00911.php


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

3 REPLIES 3

@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'

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!