SPO doc library/lists: Possible to pull all notes from an item in the notes field?

[OneWithQuestion]

In SPO lists or document libaries you can edit the properties on an item and enter notes.  Multiple notes can be entered over time.

When I look at the data brought back by PowerBI it only shows the most recent note in the Notes1 field.

Is there a way to get the full notes history, is it a child table I need to expand somewhere?

Thanks!

[v-yuezhe-msft]

@OneWithQuestion,

Based on my test, the built-in SharePoint connectors in Power BI Desktop don't contain the full notes history, as your post, it is possible to show the most recent note.

To show the full history of an item, please check these workarounds which are discussed in the similar thread below.

https://community.powerbi.com/t5/Desktop/Getting-SharePoint-List-items-with-full-history-version/td-...

Regards,
Lydia