cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TBaldwin11 Frequent Visitor
Frequent Visitor

Incorrect Syntax When Running a SQL Statement

Hello,

 

I am currently pulling data from a SQL Server into Power Bi.  While this works great, it is pulling data all the way back to 1996, which makes it take an increasing long time to refresh. I would like to only get work orders with a lagging 365 creation date. To do this, I was trying to add a filter via the "SQL Statement" advanced option.  

 

Below is what I am entering:

evaluate

(

   filter

   (

     'workorder',

     'workorder'[datestart] >= Today() -365

   )

)

 

This is the error:

 

DataSource.Error: Microsoft SQL: Incorrect syntax near 'filter'.

Details:

    DataSourceKind=SQL

    DataSourcePath=sql1028-fm1-in.amr.corp.intel.com,3180;tracssprod

    Message=Incorrect syntax near 'filter'.

    Number=102

    Class=15

 

Any help would be greatly appreciated as I am something of a novice when it comes to DAX.

 

Turner

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors