Item 'ן' already exists in the collection

[gtamir]

Hi, Upon loading query, I get this error.

"Item 'ן' already exists in the collection"

There is no '|' column in the file.

Any Idea?

Formulas:

section Section1;

shared #"Sikum 9-2019" = let
Source = Web.Page(Web.Contents("https://votes22.bechirot.gov.il/")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"סה""כ בעלי זכות בחירה", Int64.Type}, {"סה""כ מצביעים", Int64.Type}, {"שיעור הצבעה של הקולות שנספרו", Percentage.Type}, {"סה""כ הקולות הכשרים", Int64.Type}, {"סה""כ הקולות הפסולים", Int64.Type}})
in
#"Changed Type";

shared #"Results 9_2019" = let
Source = Web.Page(Web.Contents("https://votes22.bechirot.gov.il/")),
Data2 = Source{2}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data2,{{"Column1", type text}, {"Column2", type text}, {"Column3", Percentage.Type}, {"Column4", Int64.Type}})
in
#"Changed Type";

shared #"Sikum 4_2019" = let
Source = Web.Page(Web.Contents("https://votes21.bechirot.gov.il")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"סה""כ בעלי זכות בחירה", Int64.Type}, {"סה""כ מצביעים", Int64.Type}, {"שיעור ההצבעה", Percentage.Type}, {"סה""כ הקולות הכשרים", Int64.Type}, {"סה""כ הקולות הפסולים", Int64.Type}})
in
#"Changed Type";

shared #"Results 4-2019" = let
Source = Web.Page(Web.Contents("https://votes21.bechirot.gov.il")),
Data2 = Source{2}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data2,{{"Column1", type text}, {"Column2", type text}, {"Column3", Int64.Type}, {"Column4", Percentage.Type}, {"Column5", Int64.Type}})
in
#"Changed Type";

shared #"Sikum 3_2015" = let
Source = Web.Page(Web.Contents("https://votes20.gov.il/")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"סה""כ בעלי זכות בחירה", Int64.Type}, {"סה""כ מצביעים", Int64.Type}, {"שיעור ההצבעה", Percentage.Type}, {"סה""כ הקולות הכשרים", Int64.Type}, {"סה""כ הקולות הפסולים", Int64.Type}})
in
#"Changed Type";

shared #"Results 3_2015" = let
Source = Web.Page(Web.Contents("https://votes20.gov.il/")),
Data2 = Source{2}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data2,{{"Column1", type text}, {"Column2", type text}, {"Column3", Int64.Type}, {"Column4", Percentage.Type}, {"Column5", Int64.Type}})
in
#"Changed Type";

shared #"Results By Poll 3_2015" = let
Source = Csv.Document(File.Contents("D:\My_Documents\תוצאות הבחירות\Results By Poll 3_2015.csv"),[Delimiter=",", Columns=33, Encoding=1255, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{" שם ישוב", type text}, {"סמל ישוב", Int64.Type}, {"מספר קלפי", Int64.Type}, {"בזב", Int64.Type}, {"מצביעים", Int64.Type}, {"פסולים", Int64.Type}, {"כשרים", Int64.Type}, {"אמת", Int64.Type}, {"ג", Int64.Type}, {"ודעם", Int64.Type}, {"ז", Int64.Type}, {"זך", Int64.Type}, {"זץ", Int64.Type}, {"טב", Int64.Type}, {"י", Int64.Type}, {"יז", Int64.Type}, {"יך", Int64.Type}, {"יץ", Int64.Type}, {"כ", Int64.Type}, {"ל", Int64.Type}, {"מחל", Int64.Type}, {"מרצ", Int64.Type}, {"נז", Int64.Type}, {"ני", Int64.Type}, {"נץ", Int64.Type}, {"ע", Int64.Type}, {"פה", Int64.Type}, {"ף", Int64.Type}, {"ףץ", Int64.Type}, {"קנ", Int64.Type}, {"קץ", Int64.Type}, {"רק", Int64.Type}, {"שס", Int64.Type}})
in
#"Changed Type";

shared #"Results By Poll 4_2019" = let
Source = Csv.Document(File.Contents("D:\My_Documents\תוצאות הבחירות\Results By Poll 4_2019.csv"),[Delimiter=",", Columns=50, Encoding=1255, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"שם ישוב", type text}, {"סמל ישוב", Int64.Type}, {"מספר קלפי", type number}, {"בזב", Int64.Type}, {"מצביעים", Int64.Type}, {"פסולים", Int64.Type}, {"כשרים", Int64.Type}, {"אמת", Int64.Type}, {"ג", Int64.Type}, {"דעם", Int64.Type}, {"ום", Int64.Type}, {"ז", Int64.Type}, {"זי", Int64.Type}, {"זך", Int64.Type}, {"זנ", Int64.Type}, {"זץ", Int64.Type}, {"טב", Int64.Type}, {"י", Int64.Type}, {"יז", Int64.Type}, {"ין", Int64.Type}, {"יץ", Int64.Type}, {"כ", Int64.Type}, {"ךק", Int64.Type}, {"ל", Int64.Type}, {"מחל", Int64.Type}, {"מרצ", Int64.Type}, {"נ", Int64.Type}, {"נז", Int64.Type}, {"נך", Int64.Type}, {"נץ", Int64.Type}, {"נר", Int64.Type}, {"ן", Int64.Type}, {"ןך", Int64.Type}, {"ןנ", Int64.Type}, {"פה", Int64.Type}, {"ףז", Int64.Type}, {"ףי", Int64.Type}, {"ףך", Int64.Type}, {"ףנ", Int64.Type}, {"ףץ", Int64.Type}, {"צק", Int64.Type}, {"ץ", Int64.Type}, {"ץז", Int64.Type}, {"ץי", Int64.Type}, {"ק", Int64.Type}, {"קי", Int64.Type}, {"קן", Int64.Type}, {"קף", Int64.Type}, {"ר", Int64.Type}, {"שס", Int64.Type}})
in
#"Changed Type";

shared #"Results By Poll 9-2019" = let
Source = Csv.Document(File.Contents("D:\My_Documents\תוצאות הבחירות\Results By Poll 9-2019.csv"),[Delimiter=",", Columns=43, Encoding=1255, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"סמל ועדה", Int64.Type}, {"ברזל", Int64.Type}, {"שם ישוב", type text}, {"סמל ישוב", Int64.Type}, {"קלפי", Int64.Type}, {"ריכוז", Int64.Type}, {"שופט", Int64.Type}, {"בזב", Int64.Type}, {"מצביעים", Int64.Type}, {"פסולים", Int64.Type}, {"כשרים", Int64.Type}, {"אמת", Int64.Type}, {"ג", Int64.Type}, {"ודעם", Int64.Type}, {"ז", Int64.Type}, {"זכ", Int64.Type}, {"זן", Int64.Type}, {"זץ", Int64.Type}, {"טב", Int64.Type}, {"י", Int64.Type}, {"יז", Int64.Type}, {"ינ", Int64.Type}, {"יף", Int64.Type}, {"יק", Int64.Type}, {"כ", Int64.Type}, {"כי", Int64.Type}, {"כף", Int64.Type}, {"ל", Int64.Type}, {"מחל", Int64.Type}, {"מרצ", Int64.Type}, {"נ", Int64.Type}, {"נך", Int64.Type}, {"נץ", Int64.Type}, {"פה", Int64.Type}, {"ףז", Int64.Type}, {"צ", Int64.Type}, {"צן", Int64.Type}, {"ץ", Int64.Type}, {"ק", Int64.Type}, {"קך", Int64.Type}, {"קץ", Int64.Type}, {"רק", Int64.Type}, {"שס", Int64.Type}})
in
#"Changed Type";

shared #"Results By Town 3_2015" = let
Source = Csv.Document(File.Contents("D:\My_Documents\תוצאות הבחירות\Results By Town 3_2015.csv"),[Delimiter=",", Columns=32, Encoding=1255, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{" שם ישוב", type text}, {"סמל ישוב", Int64.Type}, {"בזב", Int64.Type}, {"מצביעים", Int64.Type}, {"פסולים", Int64.Type}, {"כשרים", Int64.Type}, {"אמת", Int64.Type}, {"ג", Int64.Type}, {"ודעם", Int64.Type}, {"ז", Int64.Type}, {"זך", Int64.Type}, {"זץ", Int64.Type}, {"טב", Int64.Type}, {"י", Int64.Type}, {"יז", Int64.Type}, {"יך", Int64.Type}, {"יץ", Int64.Type}, {"כ", Int64.Type}, {"ל", Int64.Type}, {"מחל", Int64.Type}, {"מרצ", Int64.Type}, {"נז", Int64.Type}, {"ני", Int64.Type}, {"נץ", Int64.Type}, {"ע", Int64.Type}, {"פה", Int64.Type}, {"ף", Int64.Type}, {"ףץ", Int64.Type}, {"קנ", Int64.Type}, {"קץ", Int64.Type}, {"רק", Int64.Type}, {"שס", Int64.Type}})
in
#"Changed Type";

shared #"Results By Town 4_2019" = let
Source = Csv.Document(File.Contents("D:\My_Documents\תוצאות הבחירות\Results By Town 4_2019.csv"),[Delimiter=",", Columns=49, Encoding=1255, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"שם ישוב", type text}, {"סמל ישוב", Int64.Type}, {"בזב", Int64.Type}, {"מצביעים", Int64.Type}, {"פסולים", Int64.Type}, {"כשרים", Int64.Type}, {"אמת", Int64.Type}, {"ג", Int64.Type}, {"דעם", Int64.Type}, {"ום", Int64.Type}, {"ז", Int64.Type}, {"זי", Int64.Type}, {"זך", Int64.Type}, {"זנ", Int64.Type}, {"זץ", Int64.Type}, {"טב", Int64.Type}, {"י", Int64.Type}, {"יז", Int64.Type}, {"ין", Int64.Type}, {"יץ", Int64.Type}, {"כ", Int64.Type}, {"ךק", Int64.Type}, {"ל", Int64.Type}, {"מחל", Int64.Type}, {"מרצ", Int64.Type}, {"נ", Int64.Type}, {"נז", Int64.Type}, {"נך", Int64.Type}, {"נץ", Int64.Type}, {"נר", Int64.Type}, {"ן", Int64.Type}, {"ןך", Int64.Type}, {"ןנ", Int64.Type}, {"פה", Int64.Type}, {"ףז", Int64.Type}, {"ףי", Int64.Type}, {"ףך", Int64.Type}, {"ףנ", Int64.Type}, {"ףץ", Int64.Type}, {"צק", Int64.Type}, {"ץ", Int64.Type}, {"ץז", Int64.Type}, {"ץי", Int64.Type}, {"ק", Int64.Type}, {"קי", Int64.Type}, {"קן", Int64.Type}, {"קף", Int64.Type}, {"ר", Int64.Type}, {"שס", Int64.Type}})
in
#"Changed Type";

shared #"Results By Town 9_2019" = let
Source = Csv.Document(File.Contents("D:\My_Documents\תוצאות הבחירות\Results By Town 9_2019.csv"),[Delimiter=",", Columns=39, Encoding=1255, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"סמל ועדה", Int64.Type}, {"שם ישוב", type text}, {"סמל ישוב", Int64.Type}, {"בזב", Int64.Type}, {"מצביעים", Int64.Type}, {"פסולים", Int64.Type}, {"כשרים", Int64.Type}, {"אמת", Int64.Type}, {"ג", Int64.Type}, {"ודעם", Int64.Type}, {"ז", Int64.Type}, {"זכ", Int64.Type}, {"זן", Int64.Type}, {"זץ", Int64.Type}, {"טב", Int64.Type}, {"י", Int64.Type}, {"יז", Int64.Type}, {"ינ", Int64.Type}, {"יף", Int64.Type}, {"יק", Int64.Type}, {"כ", Int64.Type}, {"כי", Int64.Type}, {"כף", Int64.Type}, {"ל", Int64.Type}, {"מחל", Int64.Type}, {"מרצ", Int64.Type}, {"נ", Int64.Type}, {"נך", Int64.Type}, {"נץ", Int64.Type}, {"פה", Int64.Type}, {"ףז", Int64.Type}, {"צ", Int64.Type}, {"צן", Int64.Type}, {"ץ", Int64.Type}, {"ק", Int64.Type}, {"קך", Int64.Type}, {"קץ", Int64.Type}, {"רק", Int64.Type}, {"שס", Int64.Type}})
in
#"Changed Type";

[v-shex-msft]

HI @gtamir ,

According to your error message, it seems like your table contains multiple same name columns. AFAIK, query table not allow same name columns exist in one table.

>>There is no '|' column in the file.

In addition, I can find ן columns in 'Results By Poll 4_2019', 'Results By Town 4_2019' query tables. Some table columns also has column name with Hebrew character ן.
I' m not so sure if this issue is due to power bi can't recognize Hebrew characters and replace some of characters as blank.

Regards,

Xiaoxin Sheng

[gtamir]

Thanks @v-shex-msft 

Interesting, this is a Hebrew letter, and it appears only in one column in each table.

[v-shex-msft]

Hi @gtamir ,

Maybe you can try to contact power query team with a sample file to confirm if this issue is caused by specific characters. (error message mentioned your table contains same name fields)

Regards,

Xiaoxin Sheng