SharePoint List with multiple line column and "Append Changes to existing text" turned ON, PowerBI

[djrao07]

Currently have multiple line of text column with "Append Changes to existing text" turned ON in a Sharepoint List.
I created a Power BI report to display information related to the list inclusive of those Multiple text with append changes on columns.
However, when I display the text columns in a table I am not seeing the text stored and only few row with recent changes are imported.
When view the Item in Sharepoint list, the text is there.
How can I get the full text stored in multiple line and display it in Power BI? Screeshot of same is attached.
Thanks for any assistance with this issue.

SharePoint List -MultipleLineTet-AppendExistingTextONPowerBI-MultipleLine-AppendON-Only few line are displayedSharePointList-test 2 entry of multipleline

[mblichowski]

Hi, I have the same issue with my connection to the SP list. @djrao07 have you managed to find a solution to this problem?

Thanks

[Seanv]

Good day, I also have the same issue. Is there a solution as yet?

[ChrisMendoza]

@djrao07 - Looks like you're in for some work based off https://community.powerbi.com/t5/Desktop/Getting-SharePoint-List-items-with-full-history-version/td-... .

I'm trying to imagine what you're using this method for, hard to tell with your sample. My guess is some sort of comment log? You can do some pretty nifty things using Power Apps and Power Automate to collect and transform your list. Take a look at https://www.youtube.com/watch?v=GyoD0DD_fW0 by Reza Dorrani. Specifically his 'log history' implementation.