Project ID help - long string of characters.

[acalderon]

I am pulling in data from a PWA (project web app) OData feed. One of the columns i need is the Project ID field, but in the OData feed it shows up as a long string of characters:

But in PWA, this is how Project ID is shown:

I am not sure how to change it to the P### format, and kind of confused as to why it's showing up as a long string instead of P###.

Any help/suggestions? Thanks in advance!

[v-piga-msft]

Hi @acalderon,

What data type of your Project ID in PWA, image URL or String?

And now what kind of the Project ID in Power BI Desktop? Text?

Normally, if your Project ID in PWA is image URL, you also could change it to image URL in data category in Power BI.

Please have a check.

Best Regards,

Cherry