Forum Discussion

Ekaterina's avatar
Ekaterina
Regular Visitor
9 years ago
Solved

Custom Query BI DESKTOP

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

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Ekaterina,

     

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

     

     

    Regards

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Ekaterina,

     

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

     

     

    Regards