Forum Discussion

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
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

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

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
MVP
Feb 22, 2022
Thank you for the kind words! Always happy to help the Microsoft Project community where I can.