Forum Discussion
Importing data from SharePoint lists into PowerBI [Records & Tables]
You could use Group By function in power bi power query and then do a Text.Combine function to combine with delimeter
1 Group By function with desired Column
2 In the Grouped Data Create a custom cloumn which extracts the desired data from rows
3 Use Text.Combine() function to combine them concatinate them
4 Keep Only the concatinated result by flatening the grouped one
Or You can use Table.Transform column with To.List function and then use Text.combine function to concatinate
Hi angiepowerbi99,
We would like to follow up to see if the solution provided by Akash_Varuna resolved your issue. Please let us know if you need any further assistance.
If the user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Vinay Pabbu
Hi angiepowerbi99,
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Vinay Pabbu
Hi angiepowerbi99,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Vinay Pabbu