Can I use Power Query to read a SharePoint text table

[mike_1946]

Hi,

I've been using power query from Excel extensively to get data from excel workbooks and databases, but this is my first attempt to read a SharePoint text table from a SharePoint page that is several pages deep. I've attached a .jpg pic of what I would like to read.

Any help would be very much appreciated.

Thanks,
Mike

 

[mike_1946]

I've been able to get to the specific SharePoint page with the following code. But after expanding and searching all of the columns I've not been able to determine how to access the details of the page.

let
Source = SharePoint.Tables("https://-----------.sharepoint.com/sites/EA/", [ApiVersion = 15]),
#"ca99c2c3-e701-4a86-aa7f-63cf025f3048" = Source{[Id="ca99c2c3-e701-4a86-aa7f-63cf025f3048"]}[Items],
#"Renamed Columns" = Table.RenameColumns(#"ca99c2c3-e701-4a86-aa7f-63cf025f3048",{{"ID", "ID.1"}}),
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([Title] = "POC Inventory"))
in
#"Filtered Rows