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...
Update - the [ID] Column is of type 'function', and I have never experienced this before. When I use Drill-Down on a specific [Accounts] field, the editor performs the [ID] function and returns [Accounts] as a string. However, I have only figured out how to do this on one ID at a time.
Is there anyway to perform the [ID] function to all rows using m-query?
Thanks again