Forum Discussion

bogdan_elastic's avatar
bogdan_elastic
New Member
6 years ago

Sorting by non-grouped column

Hi there, I'm looking for some guidance or hint on the below case I'm trying to solve. I'm working on an ODBC-based connector for a SQL datasource that lacks currently the capacity to sort/order by...
Need Help
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi bogdan_elastic 

 

Would you be able to visualize your problem, as a sample of data in the current state and what is the outcome that you expect?

Please, can you clarify, what do you mean by "I was wonding if there's any way to indicate this incapacity to PowerBI?"

 
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

 

bogdan_elastic's avatar
bogdan_elastic
New Member
6 years ago

Hi Mariusz ,

 

Would you be able to visualize your problem, as a sample of data in the current state and what is the outcome that you expect?

Please, can you clarify, what do you mean by "I was wonding if there's any way to indicate this incapacity to PowerBI?"

I am looking for a way to flag to PowerBI that the data source can't order by a column, if that column is not used for grouping.

Ideally, there would be a setting in SqlCapabilities passed to Odbc.DataSource, as an example.

 

So, in the full example I've given, ideally PowerBI would also group by "C2" and "C3" if ordering by these columns.

 

Regards,

Bogdan.