cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
wazdarocsta
Regular Visitor

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 when it is. I have done this both via my local PC using Edge and an Azure VM to rule out it is not a local setting. I have done repairs to both WebView2 and Edge but nothing seems to work. I would like to see if others are getting the same issue as me? (Sidenote - I can do the below in Power BI desktop no issues so it is not the query or the site)
1. Log into https://app.fabric.microsoft.com go to the (Synapse) Data Engineering experience and create a Lakehouse (preview). Go into that Lakehouse and choose New Dataflow Gen2 (preview):

wazdarocsta_0-1689257368790.png

2.  Choose Get data > Blank query - replace the query text with the following code choose a gateway and hit Next:
let
Source = Web.BrowserContents("https://www.parkrun.co.za/delta/results/latestresults/"),
#"Extracted Table From Html" = Html.Table(Source, {{"POSITION", ".Results-table-td\-\-position"}, {"PARKRUNNER", ".Results-table-td\-\-name > .compact"}, {"RUNNERDETAILURL", "[target=""_top""]", each [Attributes][href]?}}, [RowSelector=".Results-table-row"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"POSITION", Int64.Type}, {"PARKRUNNER", type text}, {"RUNNERDETAILURL", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [PARKRUNNER] <> "Unknown"),
#"Kept First Rows" = Table.FirstN(#"Filtered Rows",5)
in
#"Kept First Rows"

wazdarocsta_1-1689257595368.png

3. It will pop up an alert "We could not evaluate this query due to invalid or missing credentials." Click on Configure Connection

wazdarocsta_2-1689257734735.png

4. Because it is public www and the Authentication kind defaults to Anonymous you can simply hit Connect:

wazdarocsta_3-1689257813386.png

5a. Error: "We encountered an error when initializing the web browser. Details Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))

wazdarocsta_4-1689257949476.png

5b. Other times it has shown me error message: 

We were unable to find the WebView2 runtime. You can manually download the runtime installer here: https://go.microsoft.com/fwlink/p/?LinkId=2124703

When I go to the link and try install Webview2 it tells me that it is already installed.

 

All of this is very frustrating and means I cannot achieve what I need to using Fabric until this issue is fixed. 

 

6. Show details: (text below):

wazdarocsta_5-1689258010079.png

 

---------- Message ----------
We encountered an error when initializing the web browser.

---------- Session ID ----------
339fd36e-bb5c-4ae2-900c-619c84e5dbd4

---------- Request ID ----------
82e828a5-f96d-493a-bbd9-2d2cbac390c4

---------- Mashup script ----------
[DefaultOutputDestination = "DefaultDestination"]
section Section1;
shared DefaultDestination = Lakehouse.Contents(null){[workspaceId = "8401d000-b3c6-40e7-8ebf-b86c192e047b"]}[Data]{[lakehouseId = "be7ddef0-ae31-4ef5-9062-5543ad6fac70"]}[Data];
[BindToDefaultOutputDestination = true]
shared Query = let
Source = Web.BrowserContents("https://www.parkrun.co.za/delta/results/latestresults/"),
#"Extracted Table From Html" = Html.Table(Source, {{"POSITION", ".Results-table-td\-\-position"}, {"PARKRUNNER", ".Results-table-td\-\-name > .compact"}, {"RUNNERDETAILURL", "[target=""_top""]", each [Attributes][href]?}}, [RowSelector=".Results-table-row"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"POSITION", Int64.Type}, {"PARKRUNNER", type text}, {"RUNNERDETAILURL", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [PARKRUNNER] <> "Unknown"),
#"Kept First Rows" = Table.FirstN(#"Filtered Rows",5)
in
#"Kept First Rows";

2 REPLIES 2
lbendlin
Super User
Super User

Please provide your feedback to Microsoft so they can correct these preview issues.

 

You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

@lbendlin Thank you so much for reading through and responding. I have logged the issue as you have suggested here: Catastrophic Failure OR WebView2 runtime error whe... - Microsoft Fabric Community

I appreciate thefeedback and additional information. Regards, Warren

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors