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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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!