Custom Query BI DESKTOP

[Ekaterina]

Hello,

is it possible to introduce a custom query in Desktop? Like select * from... where...

If yes, where should I introduce it?

I need to select date range that equals the last year.

Thanks

[v-ljerr-msft · Accepted solution]

Hi @Ekaterina,

 Yes, you should be able to specify your native database query in the SQL Statement box while connecting to a database.

Regards