none
Spurious line breaks in text fields in reports. RRS feed

  • Question

  • Hi, i am connecting to POL via Excel and Power Query. Querying the projects table, the field 'Project Progress' has spurious line breaks in the text that is not present when viewed in POL. E.g. the text

    Space, the final frontier. These are the voyages of the Starship Enterprise. Its five-year mission: to explore strange new worlds, to seek out new life and new civilizations, to boldly go where no man has gone before. Many say exploration is part of our destiny, but it’s actually our duty to future generations and their quest to ensure the survival of the human species.

    May become

    Space, the final frontier. 
    These 
    are 
    the voyages of the Starship Enterprise. Its five-year mission: 

    to 
    explore strange new 
    worlds, to seek 
    out new life 
    and new civilizations, to boldly go 

    where 
    no man has gone before. Many say exploration is part of our destiny, 
    but it’s actually our duty to future generations and their quest to ensure 
    the survival of the human species.

    This happens regualrly across a number of fields and then seems to fix itself for no apparent reason. The field has been setup as  'multiple lines of text', entity is 'project', type is 'text', value to display is 'data'. It doesnt matter if i query this by power query or power bi, the result is the same.

    For reference, the query used in power query is 

    let
        Source = OData.Feed("https://XXX.sharepoint.com/sites/pol/_api/Projectdata"),
        Projects_table = Source{[Name="Projects",Signature="table"]}[Data]
    in
        Projects_table



    • Edited by rapscalli Wednesday, August 28, 2019 2:33 PM
    Wednesday, August 28, 2019 2:32 PM

Answers

All replies