Rick Bojahra on 08 Feb 2020 07:46:45
PowerBI's OData connector for Project does not allow the HTML native version of Rich Text fields to be returned.
Due to the fact that standard Odata connection to Project Online is purposely stripping the HTML from all multiline text fields, it is required to use Project Online REST interface "POURL/_api/ProjectServer/Projects" to get this information.
This creates another problem that needs to be resolved. PowerBI desktop supports connection to the Rest interface, but PowerBI Web Service does not support this connection. Making it impossible to publish a report for corporate consumption and automatic data refresh.
First, features supported in the desktop version should be supported online. Especially those related to connections and Odata. PowerBI reports created for Project ONLINE are typically consumed by ONLINE users, not desktop users.
Second, if the REST interface is not going to be supported, the standard interface needs to support multi line text in HTML.