PowerBI Dataflow - WebiView2 issue

[VOliver89]

Hi All,

Since the latest update of the datagateway I'm facing issues with web source in a dataflow.

I see that the in the update summary is written some stuff regarding this but ican't find that "check box" to be thicked/un-ticked
(https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-may-2023-release/)

My error is constantly: "Error: We were unable to find the WebView2 runtime."

the gateaway version is: 3000.174.13

the dataflow query is:

let

  Forint1 = (let

    Source = Web.BrowserContents("https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.e..."),

    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE.forextable > * > TR > TH[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE.forextable > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(4)"}, {"Column2", "TABLE.forextable > * > TR > TH[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE.forextable > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(3)"}, {"Column3", "TABLE.forextable > * > TR > TH[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(3) + TH:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(2), TABLE.forextable > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(3) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(2)"}, {"Column4", "TABLE.forextable > * > TR > TH[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(3) + TH:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(2) + TH:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(1), TABLE.forextable > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(3) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(2) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(1)"}}, [RowSelector="TABLE.forextable > * > TR"]),

    #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),

    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Currency", type text}, {"Currency_1", type text}, {"Spot", type number}, {"Chart", type text}}),

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Currency_1] = "Hungarian forint")),

    #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Spot"}),

    Spot1 = #"Removed Other Columns"[Spot]

in

    Spot1),

  Source = Web.BrowserContents("https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.e..."),

  #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE.forextable > * > TR > TH[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE.forextable > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(4)"}, {"Column2", "TABLE.forextable > * > TR > TH[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(3), TABLE.forextable > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(3)"}, {"Column3", "TABLE.forextable > * > TR > TH[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(3) + TH:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(2), TABLE.forextable > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(3) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(2)"}, {"Column4", "TABLE.forextable > * > TR > TH[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(3) + TH:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(2) + TH:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(1), TABLE.forextable > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(4) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(3) + TD:not([colspan]):not([rowspan]):nth-child(3):nth-last-child(2) + TD:not([colspan]):not([rowspan]):nth-child(4):nth-last-child(1)"}}, [RowSelector = "TABLE.forextable > * > TR"]),

  #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars = true]),

  #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers", {{"Currency", type text}, {"Currency_1", type text}, {"Spot", type number}, {"Chart", type text}}),

  #"Added Custom" = Table.AddColumn(#"Changed Type", "Forint", each Forint1),

  #"Expanded Forint" = Table.ExpandListColumn(#"Added Custom", "Forint"),

  #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Forint", {{"Forint", type number}}),

  #"Replaced Value" = Table.ReplaceValue(#"Changed Type1", "HUF", "EUR", Replacer.ReplaceText, {"Currency"}),

  #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value", "Hungarian forint", "Euro", Replacer.ReplaceText, {"Currency_1"}),

  #"Renamed Columns" = Table.RenameColumns(#"Replaced Value1", {{"Currency_1", "CurrencyName"}}),

  #"Added Conditional Column" = Table.AddColumn(#"Renamed Columns", "Custom", each if [Currency] = "EUR" then [Forint] else [Forint]/[Spot]),

  #"Changed Type2" = Table.TransformColumnTypes(#"Added Conditional Column", {{"Custom", type number}}),

  #"Renamed Columns1" = Table.RenameColumns(#"Changed Type2", {{"Custom", "ExchRate"}}),

  #"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns1", {"Currency", "CurrencyName", "ExchRate"})

in

  #"Removed Other Columns"

[VOliver89 · Accepted solution]

Hi All,

I don't know how but now suddenly started to work again.... seems like the gods of powerbi/dataflow's also wanted me to take a vacation 😄

Although it's not so funny, because if had such a solution at a client side i don't think they would had been happy if i would had said to them "chill, it will solve itself magically sooner or later"...

Thank you for the help though.

BTW i will swap this entire web source and solve it by store the content in a Dataverse table (with powerautomate) and will use the standard dataverse connector to that table, so this will not happen again.

Thx,

Oliver

[v-binbinyu-msft]

Hi @VOliver89 ,

Please try to  download the evergreen webview2 installer to be up to date: WebView2 – Microsoft Edge Developer.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VOliver89]

Already tried. We installed it on the on-prem server where the gateway i, and nothing happened 😕