Forum Discussion

shamsuddeenvp's avatar
shamsuddeenvp
Icon for Post Patron rankPost Patron
10 years ago

How can i user sort by other column in live/direct query to SQL server table

Dear Team,   How can I sort a visual by a column which is not used in the visual but available in data set. I know we can do this in SSAS cube. I want to implement this for the live/direct query on...
Need Help
Kavita's avatar
Kavita
Frequent Visitor
9 years ago

Not sure why the Modelling ribbon is disabled for you! 

 

This is how it looks for me in Direct Query mode.

 

And you cannot sort based on measure :(

reubster's avatar
reubster
Frequent Visitor
9 years ago

Hi,

 

Apologies for the delay, I finally found this reply. 

Looks like there's a functionality difference between Direct Query to SSAS, and Direct Query to SQL... and it also depends on the data type.

Cheers,

Reuben

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Are this behavior and other limitations of Direct Query mode documented in a single place anywhere in Power BI documentation?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Are the limitations of Direct Query mode documented anywhere?

    • reubster's avatar
      reubster
      Frequent Visitor
      9 years ago

      Hi,

       

      I'm sorry, I don't know. This kind of thing seems to change quite frequently.

       

      R

       

      • DaliborPuljiz's avatar
        DaliborPuljiz
        New Member
        8 years ago

        Confirmed - it still not working with October 2017 update, whereas custom sorting runs fine in cube preview (SSIS).