Status:
Done
Catastrophic Failure OR WebView2 runtime error when using blank query (Source = Web.BrowserContents)
I am trying to use Microsoft Fabric (Trial Lisence) Dataflow Gen2 to Get Data (a webscrape) but it either gives me a Catastrophic Error Failure or it complains that WebView2 is not installed even whe...
We have this same issue. We have Webview2 and the latest Gateway version installed no our on-premises server. We have a Web.BrowserContents Dataflow to create an entity that was working until the Upgrade to the latest version of the Gateway. After the upgrade and installation of Webview2 we get the error. Error and Power Query below.
We encountered an error when initializing the web browser.
Details
Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
let
// Get the data from the table on the web site.
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".info A"}, {"Column2", ".name + *"}, {"Column3", ".date"}, {"Column4", "SPAN:nth-child(2) *"}}, [RowSelector = ".content-links LI"]),
// Sept. is the standard for associated press and needs fixed and set to Sep. so that it can be parsed properly.
#"Replaced Value for Sept." = Table.ReplaceValue(#"Extracted Table From Html", "Sept.", "September", Replacer.ReplaceText, {"Column3"}),
// Need the Column3 to be a datetime.
#"Changed Type to Date" = Table.TransformColumnTypes(#"Replaced Value for Sept.", {{"Column1", type text}, {"Column2", type text}, {"Column3", type datetime}, {"Column4", type text}}),
// Put the correct names on the column headers.
#"Renamed Columns" = Table.RenameColumns(#"Changed Type to Date", {{"Column1", "Training Name"}, {"Column3", "As of Date"}}),
// The extra 2 columns can be removed at this point.
#"Removed Columns" = Table.RemoveColumns(#"Renamed Columns", {"Column4", "Column2"}),
// Need to set the name column.
#"Added Training Name" = Table.AddColumn(#"Removed Columns", "Training Type", each "On-Demand Webinar"),
// Type is always 3 for On-Demand Webinars.
#"Added Training Type" = Table.AddColumn(#"Added Training Name", "TrainingTypeID", each 3),
// Change Type to Text and TypeID to integer.
#"Changed Types" = Table.TransformColumnTypes(#"Added Training Type", {{"TrainingTypeID", Int64.Type}, {"Training Type", type text}}),
#"On-Demand Webinars (Web Site Scrape)-4173206F662044617465-autogenerated_for_incremental_refresh" = Table.SelectRows(#"Changed Types", each DateTime.From([#"As of Date"]) >= RangeStart and DateTime.From([#"As of Date"]) < RangeEnd)
in
#"On-Demand Webinars (Web Site Scrape)-4173206F662044617465-autogenerated_for_incremental_refresh"