SharePoint List with Multi-Line Text and Append Changes Enabled Only Displays Most Recent Data

This seems to be somthing that has been brought up multiple times and quite frankly I don't think there is a good solution.

I am here trying to figure out if there is something that I have mised between AI, Search Engines and YouTube.

When I import my SharePoint list into PowerBI and select either a card or other visualization what I see is the most recent entry in the list of appended changes.

When I disable {Append Changes} all of the data comes through and while that might functionally work it does not work for the way I want my users to interface with and edit this particular field.

The problem is simple to understand although I have seen everything but the actual issue addressed.

For Microsoft, this should be easy just store the entries in an array and pass the array across to PowerBI then require users to expand the array in Power Query to get all entries.

But as it stands now does anyone have the answer to this vexing problem?bIWithoutAppendlistWithoutAppendpowerQueryWithoutAppendbiWithAppendlistWithAppendformWithAppendpowerQueryWithAppend