Loading multiple SharePoint page libraries into the same query

MichaelHutchens,

Try this solution. The concept is to create a URL table with a row for each library, and create a custom function that will loop through each library.

https://www.howtoexcel.org/how-to-extract-data-from-multiple-webpages/ 

MichaelHutchens,

Try using Web.Contents as suggested by KNP:

let GetResults=(URL) =>

let
    Source = Web.Page(Web.Contents(URL)),
    Data1 = Source{1}[Data]
in
    Data1

in GetResults

If this doesn't work, try Source{0} instead of Source{1}.