Forum Discussion
How to Perform Power Query (M) Drill down on all Rows
Hello - I have been working on a 3rd party connector that returns a Jobs table in the query editor. In the Jobs table, there is a column called [Accounts] which in the query editor view only contains...
Cells can look like this if you have a bunch of white space at the beginiing. Try doing Clean and Trim on the Accounts column to see if this is this issue.
https://community.powerbi.com/t5/Power-Query/Ellipsis-in-Power-query-value-field/td-p/2141281