DataFormat.Error

[IanCockcroft]

Hi guys,

I am going through a tutorial to build a report for  the football worldcup.

https://www.youtube.com/watch?v=i24MdCAjL68

After pulling data from web and inserting code from   the tut

i get an error

DataFormat.Error: The specified culture is not supported. Details: en-SE

the code:

let
    Source =                                                                          Web.Page(Web.Contents("http://www.fifa.com/worldcup/groups/")),
    #"Removed Columns1" = Table.RemoveColumns(Source,{"Source", "ClassName"}),
    #"Expanded Data1" = Table.ExpandTableColumn(#"Removed Columns1", "Data", {"", "MP", "W", "D", "L", "GF", "GA", "+/-", "Pts"}, {"Column1", "MP", "W", "D", "L", "GF", "GA", "+/-", "Pts"}),
    #"Filtered Rows" =                                                      Table.SelectRows(#"Expanded Data1", each ([Caption] <> "Document")),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Filtered Rows", "Column1", Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.Csv), {"Column1.1", "Column1.2"}),
    #"Trimmed Text" = Table.TransformColumns(#"Split Column by Delimiter",{{"Column1.2", Text.Trim, type text}}),
    #"Filtered Rows2" = Table.SelectRows(#"Trimmed Text", each ([Column1.2] <> null and [Column1.2] <> "")),
    #"Added Custom" = Table.AddColumn(#"Filtered Rows2", "Flag URL", each "https://fsprdcdnpublic.azureedge.net/global-pictures/flags-fwc2018-4/"&Text.Lower([Column1.2])),
    #"Extracted Text After Delimiter" = Table.TransformColumns(#"Added Custom", {{"Caption", each Text.AfterDelimiter(_, " "), type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Extracted Text After Delimiter",{{"Caption", "Group"}, {"Id", "GroupId"}, {"Column1.1", "Teams"}, {"Column1.2", "Team code"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"MP", Int64.Type}, {"W", Int64.Type}, {"D", Int64.Type}, {"L", Int64.Type}, {"GF", Int64.Type}, {"GA", Int64.Type}, {"+/-", Int64.Type}, {"Pts", Int64.Type}}),
    #"Extracted First Characters" = Table.TransformColumns(#"Changed Type", {{"Group", each Text.Start(_, 1), type text}}),
    #"Renamed Columns1" = Table.RenameColumns(#"Extracted First Characters",{{"+/-", "Diff"}})
in
    #"Renamed Columns1"

any ideas why? and how to fix it?

en-SE seems to be Sweden. I think her settings are set to SE

not sure

 thanks guys

Ian

[Thejeswar]

@IanCockcroft,

Is this the code that you are using?

If so, it is working fine for me

I was able to import the data and build my visualization using the code snippet that you shared

If there is something else you are adding to this, sharing that would help!!

[IanCockcroft]

Hi Thejeswar, yes, thats the exact code.

I am also wondering if it might be my OS or even PBI version(i am using may 2018 64 bit on windows 7)

Last night, I was working on it at home(windows 10) and there was no error.

Does that maybe give you some ideas?

cheers

Ian

[Thejeswar]

@IanCockcroft,

Yes that could also be an issue.

I am using PBI 2018 May version, Windows 10, It is working perfectly fine.

Give it a shot by installing the latest version in your machine. If that does not solve the issue, may be it is a problem with some OS settings or so

cheers

Thejeswar

[IanCockcroft · Accepted solution]

Hi Thejeswar,

I seem to have solved it.

in the options page under local settings, you have the ability to add a culture.

I added sweden. seems to have worked.

cheers

[Thejeswar]

Ok great then!!!