Forum Discussion

manojnikam3008's avatar
manojnikam3008
Frequent Visitor
5 years ago

Rich Text format issue while fetching data from project online using ODataFeed connection

Hello Experts,

 

Is there any way to fetch data in HTML format from Project Online to Power BI report. Currently, I am using ODataFeed connection to bring data from Project Online to Power BI Data model but i am losing all the formatting that project online has, and data appears as plain text (not even showing line breaks). Therefore, i want to know other alternatives to connect to Project Online. I have already tried Project Online App from but it's not giving me all the fields and can't even download PBIX file for modification.

 

Thanks in advance,

Manoj Nikam

Need Help

2 Replies

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi manojnikam3008 ,

     

    First, please check if the "Type Detection" has been set as "Always detect column types and headers for unstructured sources" or "Detect column types and headers for unstructured sources according to each file's setting".

     

    If this has been set, try to detect data type manually like this:

    Reference: Automatically detect and change the types of all columns at once in Power Query.

     

    Then, for "line breaks", it is needed to keep "show whitespace" option selected.

     

    Reference: Power BI Desktop March update feature summary | Microsoft Power BI blog | Microsoft Power BI

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • manojnikam3008's avatar
    manojnikam3008
    Frequent Visitor
    5 years ago

    Hello Icey,

     

    Thank you for the response. I have double checked the things you have mentioned above and found them similar to what you have suggested.

     

    I am sharing the screenshots of the difference between our MS project online and Power BI data to give you more idea.

     

    MSP Input : with formatting

    MSP

     

    Power BI Output: Plain text with no line breaks

    Power BI