Show all info from a multiple lines of text column

[PBI_Lurin]

Hi,

I got a list in a sharepoint with some columns formated as mutliple lines, the information shown in the sharepoint is like the following for the Actions Log column

NN (8/25/2023 10:27 AM)
​test 12:27 (3rd round)
NN (8/25/2023 10:16 AM‌‌)
​test 12:16
NN (8/25/2023 9:04 AM‌‌)
​test data 11:04 25-Aug-23

However when I pull this information into Power BI I only see the newest input.

How can I do to see all the historical data and not only the latest one?

[ImkeF]

Thanks, 
yes, that makes sense now.
Unfortunatly I don't know if/how this can be solved. I am getting the same result as you: Only the latest items will be shown.

[ImkeF]

Hi @PBI_Lurin ,
sorry, I cannot replicate why your're getting all this html-stuff here.
I would expect the result to be a proper table with columns of different results.

[PBI_Lurin]

Well, the data is coming from a multiple line text column with enriched text formant that allows append data...

basically when you look to the list you see  the "View Entries" text on those columns, then you need to click there to see the real data.

[PBI_Lurin]

Hello ImkeF,

The raw output in power query is shown below, as you see there is no reference to previous information.

<div class="ExternalClassA4089336675447A294EC6AAC5839A6F0"><div>​test 12&#58;27 (3rd round)<br></div></div>

By the way, the connection with the data is like this:

Source = SharePoint.Tables("https://owensillinois.sharepoint.com/teams/MySite", [ApiVersion = 15]),
#"05f2db8b-676c-4b06-97bf-7749e28eac84" = Source{[Id="05f2db8b-676c-4b06-97bf-7749e28eac84"]}[Items],

[ImkeF]

Hi @PBI_Lurin ,
sometimes this is just a display issue. Try removing non-printable characters by going to:
Transform -> Format  -> Clean
Otherwise please post a screenshot of how this looks in the query editor.