Forum Discussion
rocky09
Solution Sage
Solution SageData order same as the Original Query
I am using Direct Query method to pull data from Oracle Server. In the Original Query, I have sorted few columns and in Query Editor, I can see the same order as in the Original Query. But, when...
I found a solution.
What I did was, I have created a custom column and Concatenated the required columns then put that custom column and sorted.
TomMartens
Super User
Super UserHey,
I'm not sure what you mean by you don't get the same data order, I guess you are referencing the order of the rows.
The effect can be one of these
- Unique Rows
The Rows in the table are not unique, this means that numeric values will be aggregated -> 100 rows in the source table will be aggregated to 97 rows in the Power BI table visual - Implicit Ordering of non numeric columns
I guess you have to consider the following
- Create a measure that sorts the rows accordingly using RANKX
Depending of the number of rows, ordering can be slow.
Regards,
Tom
rocky09Solution Sage
Solution SageThanks Tom,
yes, i am referring to "order of the rows".
I guess, RankX won't work in Direct Query Mode.
- TomMartens
Hey,
according to this list:
RANKX is one of the not optimized functions (for direct query), I just tested it and it works. I have no idea how this will behave from a performance perspective.
Regards,
Tom