Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 drag all the fields into a table report. I am not getting the data order as in the Original Query.
Can anyone advise, how can i get the data order as in the original query.
Solved! Go to Solution.
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.
Hey,
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
I guess you have to consider the following
Depending of the number of rows, ordering can be slow.
Regards,
Tom
Thanks Tom,
yes, i am referring to "order of the rows".
I guess, RankX won't work in Direct Query Mode.
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
Thank you again,
but, not working. I am getting the error that RANKX cannot be used on Direct Query.
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.
Hey, this is cool.
Maybe this post is of interest:
prior to the July release there has been an option to allow unrestricted measures (meaning allow more DAX functions in measures) using direct query.
Maybe you want to check if you have the "preview" feature "Composite Models" enabled.
Options -> Preview Features.
I tested RANKX in direct query mode against a SQL Server table without an error message.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |