Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dax/Mquery syntax to include a query within the load statement.

Need another pair of eyes to see where I am missing something to allow for this data source with a query>

 

= let
Source = Sql.Database("Test", "Reporting", [Query="SELECT * FROM [dbo].[Invoice] WHERE [InvoiceDate] >= DATEADD(DAY, -90, GETDATE()) ORDER BY [InvoiceDate] DESC)
in
Reporting

 

Please help.

 

Thanks,

 

karen

1 Reply

  • Anonymous seems like you are missing a quote