Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Create index column in DirectQuery mode

Hi all!   I have a simple problem that I can't find a way to solve and I haven't found anything related online. I have sorted data imported using DirectQuery mode and I need to create a index colum...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , I doubt you can add that in direct query mode, Maybe add rank or row number in a database query

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello amitchandak,

     

    Thanks for the reply. Will try using rank and last case I will go to the source.

     

    When you say row number in a database query are you refering to importing the data using a SQL statment that adds the index?

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      Anonymous , for a few databases you can write a query in the direct query mode too, In that case, you can use some functions like row_number etc