The column '#' of the table wasn't found.

[ElioAngarita]

Hello, i've been working with the data from a spreadsheet i own with no issue at all. Fro mall of the sudden this messgae appeared: "The column '#' of the table wasn't found." Now i can't update my dashboard.

Is there any solution for this that won't affect my dashboard?

This is the code from the advanced query editor: 

Let

Source = Excel.Workbook(Web.Contents("https://esites.enbridge.com/sites/accountspayable/Shared%20Documents/AP%20Helpdesk%20Resources/Escal..."), null, true),
#"Esc Tickets (All)_Sheet" = Source{[Item="Esc Tickets (All)",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Esc Tickets (All)_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"#", Int64.Type}, {"Ticket Number", type text}, {"Category", type text}, {"Type", type text}, {"Closure Code", type text}, {"Expeditor Name", type text}, {"Escalated Date", type date}, {"Assigned to (Name)", type text}, {"Closure Date", type date}, {"Status", type text}, {"Business Days", Int64.Type}, {"Resolution time (days)", Int64.Type}, {"Comments", type text}, {"Update", type date}, {"Requestor", type text}, {"Column16", Int64.Type}, {"Column17", type date}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"#"})
in
#"Removed Columns"

Applied steps:

Source

Navigation

Promoted Headers

Changed Type

X Removed Columns

Thank you in advance, 

[v-shex-msft]

Hi @ElioAngarita,

I'd like to suggest you change the active steps to confirm which query steps show this issue at first to help us clarify the scenario.

In addition, can you please export your records to create some dummy data with the same data structure for test? It will be helpful for troubleshooting.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[az38]

Hi @ElioAngarita 

are you sure you still have a column "#" in "Esc Tickets (All)" sheet?

if no, try this code

Let

Source = Excel.Workbook(Web.Contents("https://esites.enbridge.com/sites/accountspayable/Shared%20Documents/AP%20Helpdesk%20Resources/Escal..."), null, true),
#"Esc Tickets (All)_Sheet" = Source{[Item="Esc Tickets (All)",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Esc Tickets (All)_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{ {"Ticket Number", type text}, {"Category", type text}, {"Type", type text}, {"Closure Code", type text}, {"Expeditor Name", type text}, {"Escalated Date", type date}, {"Assigned to (Name)", type text}, {"Closure Date", type date}, {"Status", type text}, {"Business Days", Int64.Type}, {"Resolution time (days)", Int64.Type}, {"Comments", type text}, {"Update", type date}, {"Requestor", type text}, {"Column16", Int64.Type}, {"Column17", type date}})
in
#"Changed Type"

[ElioAngarita]

Hi @az38, thank you for your response.

No, i dont have any column with that name 😕 but i did notice that one of them had a weird name i didnt put, i think it might have been "#" it makes sense. I'll change it's name and i'll let you know.

In any case, should i just overwrite the text i have in that query for the code you're providing?

[az38]

@ElioAngarita 

I think it could be enough to use my code as data source