Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

PowerBI Dataflow - WebiView2 issue

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
    #"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),
  #"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"



Dataflow
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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