drill into SharePoint list column items with "Append to existing text" selected.

[benglen]

Hello, my team uses a SharePoint list to keep track of projects they are working on and to update the status and issues related to the projects. I have a power BI report that connects to the SharePoint list for reporting purposes. I would like a way to drill into the text of the status details column so it actually shows the content and not just the url to the list item. The column type is multiple lines of text with the option checked to append to existing text.  When viewing the list item in the SharePoint Grid it Creates a Hyperlink in that status column to the actual list item. This hyperlink is also what shows up when you connect in Power Query.  Thus, one cannot actually see the status details in Power BI.  they can just see the link. I'm trying to pull in the actual content of that status details column. I tried connecting directly to a list item using the web connector but it did not like that. If I could connect via web it would be something akin to connecting to a paginated webpage since the sharepoint list item is at the end of the url. 

[benglen · Accepted solution]

I found the solution Here. Basically I had to get the full version history of the items invoking the custom function provided in this thread

[lbendlin]

I tried connecting directly to a list item using the web connector but it did not like that.

Please elaborate.  Usually this is the right approach.  You can also consider using ODATA queries.