Capturing Metadata of your Web.Contents calls – Using REST APIs in Power Query

Summary Any value in Power Query can store info in a metadata record. “Datasources” often have extra info. Web.Contents exposes the full request url including the Query variables, request headers, HTTP Status codes, and more. You can view the final query here: Part 1 – Capturing Response Metadata.pq or as a pbix Finding the binary … Continue reading Capturing Metadata of your Web.Contents calls – Using REST APIs in Power Query