Sharepoint List Issue

[Ramkumar_Kashya]

Hi All,

We have a project tracker list in Sharepoint and the Assigned To column can have multiple resources assigned to a task. When creating a dashboard and trying to display resources in the Gantt view in Power BI I am getting "#12" instead of the resource name(s). I exported the list to excel and I am seeing that there is a ";#12" after the resource name when there is only one person assigned to the task and multiple semi-colon,hashtag, number sequence when multiple resources are assigned.

How can I get rid of the special characters that are being inserted by Sharepoint and to display the resource names in the dashboard?

Best Regards,

Ramkumar

[ppm1]

Please see this article too for another way to pull your data, including expanded columns like people info.

Updated – Get SharePoint List Data … Fast – Hoosier BI

Pat

[ichavarria]

Hi @Ramkumar_Kashya,

To get rid of the special characters and display the resource names in the dashboard, you can use the following steps:

1. Create a new column in the project tracker list in SharePoint that extracts the resource names from the Assigned To column. You can do this by using the following formula in a calculated column:

   =IF(ISBLANK([Assigned To]),"",IF(ISNUMBER(FIND(";#",[Assigned To])),LEFT([Assigned To],FIND(";#",[Assigned To])-1),[Assigned To]))

   This formula checks if there are multiple resources assigned to a task, and if so, it extracts the first resource name before the ";#" separator. If there is only one resource assigned, it simply displays that resource name.

2. Refresh the data in Power BI to pull in the new calculated column.

3. Use the new column you created as the "Resources" column in your Gantt chart visual.

4. Format the visual to show the Resource names in the desired way.

By following these steps, you should be able to display the resource names in your dashboard without the special characters that SharePoint adds.

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly.