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
reubster's avatar
reubster
Frequent Visitor
9 years ago

"This works absolutely fine for the Direct Query mode"

Err.. not for me it doesn't. The entire Modelling ribbon is disabled. 

I can sort by a column in the Tabular Model, but not by a measure value.... or can I? 

 

 

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