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
