Forum Discussion
Resolver ICustom sorting a column from a Direct Query data source
Hi shadowsong42 ,
- you cannot create a direct relationship between a Direct Query table and a calculated table, you can import specific tables or columns from your Direct Query source.
- Once you have your reference table in Import mode, you can create a relationship between this table and the Direct Query table.
- This relationship will allow you to sort the Direct Query column based on the values in your imported reference table.
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Resolver IMy temporary solution is to load a table containing only the sorting of the ones I care about. That correctly filters the ones I care about to the top and leaves the rest in alphabetical order.
This is temporary because if the list of things I care about changes, it will still require me to delete and re-create the table, the relationship, and the columns being referenced in my visuals . I could probably link an external file, but this dashboard is going to be transferred to a new owner using a different workspace, so I don't want to require a link to either my personal cloud storage or to the old workspace.
Is there another way to get this data into my data model that will let me edit the table values and rows after the fact?