Solved: Re: Dax/Mquery syntax to include a query within th...

Anonymous · ‎04-19-2019

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

parry2k · ‎04-19-2019

@Anonymous seems like you are missing a quote

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎04-19-2019

@Anonymous seems like you are missing a quote

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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

Helpful resources

Power BI Monthly Update - April 2024

How to Get Your Question Answered Quickly