Forum Discussion
Need help with Project Online - Custom field (text) - PowerBI
Hello,
I have created several custom fields (text value, Multiple lines of text) in Project Online, Project level.
However, when the fields are imported in powerbi, the carriage return is not recognized by powerbi and all lines appear in 1 line !
For example:
Project online:
Next month activities (text field): the following texts are entered within the field:
- Finalize business case
- Define deliverables at high level
- Define key milestones
PowerBI:
Next month activities (text column)
- Finalize business case - Define deliverables at high level - Define key milestones
Can you please help !
Thank you
Hello Tom_Nguyen ,
This is due to the Project Online reporting API removing all the HTML mark up. See a blog post here:
Paul
3 Replies
Hello Tom_Nguyen ,
This is due to the Project Online reporting API removing all the HTML mark up. See a blog post here:
Paul
- Tom_NguyenCopper ContributorThanks Paul! Will definitely check out your blog posts.
p/s: I'm a fan of yours and can't believe you would one day response to my question !!- Thank you for the kind words! Always happy to help the Microsoft Project community where I can.