Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.