Power Bi and Sharepoint iteration

[tylerspck]

Hello all,

I have been searching for a solution for this issue I've been working on, but have not been successful so I figured I would ask the hive mind.  For one project I'm working on, I am using a SharePoint list that was created to track tasks that are needed to be completed.  In the "assigned to" column, there are some rows/tasks that are assigned to multiple people.  This creates a list in that row.  I need to iterate the entire row for each value in that list.  How would I start to accomplish this?

[tylerspck]

Of course there is an option for rows that way!  Thanks.  Of course I made it much more difficult than what it really should be

[negi007]

@tylerspck Will it be possible for you to share some more details about that you are trying to achive. It will be great if you can share what you currently have and what you wish to have from that. 

[tylerspck]

Currently, I have some data being imported from an Online Sharepoint file and some of the rows are like the example is below.

I am trying to find a way to iterate the above example to like what I have below, where every row is repeated for each name.

Hope this helps clarify the issue.

Thanks in advance

[V-lianl-msft · Accepted solution]

Try using this button in the query editor: