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): 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" 3. It will pop up an alert "We could not evaluate this query due to invalid or missing credentials." Click on Configure Connection 4. Because it is public www and the Authentication kind defaults to Anonymous you can simply hit Connect: 5a. Error: "We encountered an error when initializing the web browser. Details Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) 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): ---------- 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";
... View more
v-xiaoyan-msft
on:
Power BI Embedded with DirectLake Dataset Error
Hi @aleckealey18 ,
Please try updating Power BI Desktop to the latest version. Alternatively, you could try using a different connector, such as the ODBC connector that the user has already successfully used, or a third-party connector that is compatible with Snowflake.
Best Regards,
Community Support Team _ Neeko