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?
v-aatheequeCommunity Support
Hi shadowsong42
Thanks for reaching out to Microsoft fabric Community Forum.- Navigate to Home > Enter Data and input your key values along with the desired sort order. This table will be integrated directly into your PBIX model, eliminating the need for any external links.
- When updates are needed, go to Transform Data > Power Query Editor, where you can directly modify the rows or values. This approach ensures your visuals and relationships remain intact without needing to recreate anything.
- Just ensure the destination is accessible to the new owner’s workspace.
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!- shadowsong42
v-aatheeque wrote:- When updates are needed, go to Transform Data > Power Query Editor, where you can directly modify the rows or values. This approach ensures your visuals and relationships remain intact without needing to recreate anything.
How do I directly modify rows or values in Power Query Editor? If I right click on a value in the table, I can choose "replace values", which appears to be a find and replace across the whole table. But I don't see anything about adding or removing rows, or pasting new data over existing data.
- lbendlin
Super User
That's not something you do in Power Query. You modify the data via code, not via direct edit.
