Forum Discussion

Tom_Nguyen's avatar
Tom_Nguyen
Copper Contributor
Feb 21, 2022
Solved

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 recog...
Business Intelligence
Online
Paul_Mather's avatar
Paul_Mather
MVP
Feb 22, 2022

Hello Tom_Nguyen ,

This is due to the Project Online reporting API removing all the HTML mark up. See a blog post here: 

https://pwmather.wordpress.com/2018/01/01/projectonline-powerbi-report-include-html-formatting-ppm-pmot-powerquery-odata-rest-part-1/ 

https://pwmather.wordpress.com/2018/01/03/projectonline-powerbi-report-include-html-formatting-ppm-pmot-powerquery-odata-rest-part-2/ 

https://pwmather.wordpress.com/2018/01/16/projectonline-powerbi-report-include-html-formatting-ppm-pmot-powerquery-odata-rest-part-3/ 

Paul

  • Tom_Nguyen's avatar
    Tom_Nguyen
    Copper Contributor
    Feb 22, 2022
    Thanks 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 !!
    • Paul_Mather's avatar
      Paul_Mather
      MVP
      Feb 22, 2022
      Thank you for the kind words! Always happy to help the Microsoft Project community where I can.