![]() Not for any reason other than it’s a website with a few tables on it. In my example I’m going to use the NZ Ministry of Health Coronavirus information. When you add a new data source in Power Query and choose Web, after connecting to the URL you’re shown a list of tables. The documentation for this function for a non-frontend dev is pretty much incomprehensible, but thankfully Power BI and Excel Power Query editors give you a nice GUI for selecting any tables found in the input text. Power Query (M) language has a built-in function for parsing HTML into tables, the function is called Html.Table. Use Transform Data using Power Query action to construct a table from the text in the SQL table.Use a Flow or Logic App to save the raw HTML response from the website into a SQL table.Use Power BI Desktop to connect to the web page and select the table you want. ![]() Warning: This isn’t for the faint hearted, and if you’re a full code developer you would just do this in an azure function or something. A premium Power Automate license, or access to an Azure subscription (Logic Apps).Power BI Desktop or a recent version of Excel.It’s the result of a few hours of messing around and getting frustrated so hopefully it’ll help someone avoid that. However, you can piece together a few native connectors and elements of the Power Platform to make a pretty clean job of it yourself without being a code whizz. If there was it would be pretty tricky to set up. There isn’t a native web scraping action in Power Automate/Logic Apps that I know of. This blog is about how to turn HTML content into useable data in Power Automate or Logic Apps using Low Code/No Code techniques.
0 Comments
Leave a Reply. |