Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Community,
I have a question related to Microsoft Planner Export to Excel function. It gives multiple assigned task values with semi colon as "Name1 Surname1; Name2 Surname2". It is recognized as one collapsed data. I want to be able to filter as two different person with this data so I can get correct "Members Assignment Chart". What is the best possible way for this?
Additional Information
These "Name1 Surname1; Name2 Surname2" persons are belong to a office365 gorup. So I tried to to export this data to an online Sharepoint list. The names are recognized as People inside the group. Then I tried to connect this to Power BI. But the values are recognized as a List. When I extracted the values, again it was recognized as one data in row. The image is below.
Solved! Go to Solution.
Hi @Anonymous ,
Please expand the data by click the icon.
Hİ @v-frfei-msft ,
Thank you for the solution offer. I expanded the excel data as rows with Split Column button. This option worked for my raw excel data. So, I eliminated the Sharepoint list step.
For planner reporting, going with the row option is very useful since it is possible to count distinct values of rows. Planner Export option gives unique task id for this purpose I believe.
Thanks again for your help.
Hi @Anonymous ,
Please expand the data by click the icon.
Hİ @v-frfei-msft ,
Thank you for the solution offer. I expanded the excel data as rows with Split Column button. This option worked for my raw excel data. So, I eliminated the Sharepoint list step.
For planner reporting, going with the row option is very useful since it is possible to count distinct values of rows. Planner Export option gives unique task id for this purpose I believe.
Thanks again for your help.
Check out the July 2025 Power BI update to learn about new features.