Courses / Power Query (Get & Transform)
25. Web connector basics (Power Query M)
Importing data from a web URL and choosing table/HTML/page options in the Web connector.
Power Query M
Web connector basics (Power Query M)
A way in Power Query to import a web page or web API response into a table by fetching the URL and choosing how to interpret the response (HTML tables, raw page, or structured data).
"I want the table from this web page into Excel without copying and pasting."
Power Query's Web connector fetches a URL (via Web.Contents) and then you choose how to interpret the response: Web.Page for HTML tables, Csv.Document/Json.Document for structured responses, or Binary.Buffer for downstream processing.
"I want the table from this web page into Excel without copying and pasting."
Power Query's Web connector fetches a URL (via Web.Contents) and then you choose how to interpret the response: Web.Page for HTML tables, Csv.Document/Json.Document for structured responses, or Binary.Buffer for downstream processing.