Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.