Could not load file or assembly 'CefSharp.Core.dll' or one of its dependencie

[marcinmazur]

Hi,

The created code in Power Bi Desktop works correctly. 

After publishing to https://app.powerbi.com/ I get an erro.

Where do I make a mistake?

Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We were unable to retrieve the contents of 'https://www.gpw.pl/wskazniki'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"Exit Code: -532462766\r\nStandard Output:\r\n\r\nStandard Error:\r\n\nUnhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'CefSharp.Core.dll' or one of its dependencies. The specified module could not be found.\r\n at Microsoft.Mashup.CefHelper.Program.Main(String[] args)\n"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Table 2.

let
Source = Web.BrowserContents("https://www.gpw.pl/wskazniki"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE[id='footable_K'] > * > TR > :nth-child(1)"}, {"Column2", "TABLE[id='footable_K'] > * > TR > :nth-child(2)"}, {"Column3", "TABLE[id='footable_K'] > * > TR > :nth-child(3)"}, {"Column4", "TABLE[id='footable_K'] > * > TR > :nth-child(4)"}, {"Column5", "TABLE[id='footable_K'] > * > TR > :nth-child(5)"}, {"Column6", "TABLE[id='footable_K'] > * > TR > :nth-child(6)"}, {"Column7", "TABLE[id='footable_K'] > * > TR > :nth-child(7)"}, {"Column8", "TABLE[id='footable_K'] > * > TR > :nth-child(8)"}, {"Column9", "TABLE[id='footable_K'] > * > TR > :nth-child(9)"}, {"Column10", "TABLE[id='footable_K'] > * > TR > :nth-child(10)"}, {"Column11", "TABLE[id='footable_K'] > * > TR > :nth-child(11)"}, {"Column12", "TABLE[id='footable_K'] > * > TR > :nth-child(12)"}}, [RowSelector="TABLE[id='footable_K'] > * > TR"]),
#"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Lp", Int64.Type}, {"Kod", type text}, {"Nazwa", type text}, {"Sektor", type text}, {"Liczba wyemitowanych akcji", Int64.Type}, {"Wartość rynkowa (mln zł)", type number}, {"Wartość księgowa (mln zł)", type number}, {"Raport finansowy Data", type date}, {"Raport finansowy Typ", type text}, {"C/WK", type text}, {"C/Z", type text}, {"Stopa dywidendy (%)", type text}})
in
#"Changed Type"

 

[marcinmazur]

Hi,

The error occurs in the latest version.

[GilbertQ]

What happens if you try and get the data source working by removing the tick for "Skip Test Connection"?

[marcinmazur]

Nothing change,

[GilbertQ]

Hi there

It appears that you are not running the latest version of the Gateway.

If you can please install the latest version?