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.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors