Need another pair of eyes to see where I am missing something to allow for this data source with a query>
Source = Sql.Database("Test", "Reporting", [Query="SELECT * FROM [dbo].[Invoice] WHERE [InvoiceDate] >= DATEADD(DAY, -90, GETDATE()) ORDER BY [InvoiceDate] DESC)
Solved! Go to Solution.