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 II'm not sure how to do that. I thought the whole data source had to be either Direct Query or Import. Are you saying I can import a specific column or table out of my Direct Query data source, and the relationships between Direct Query to imported to calculated will function properly, unlike between Direct Query and my calculated table?
Community SupportHi 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!
- v-aatheeque
Hi shadowsong42 ,
If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.
We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Fabric Community Forum.
- v-aatheeque
Hi shadowsong42 ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!