Custom 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!