Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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,
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
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"
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?
I think it could be enough to use my code as data source
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |