Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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"
Hi,
The error occurs in the latest version.
Nothing change,