cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
drewlewis15 Member
Member

Re: fix query error due to excel numeric stored as text error

Yup!  That is where the error is occuring.  

 

I have corrected your "Changed Type" step to treat that field as text.  The change is highlighted in green if you scroll to the right.

 

let
    Source = Excel.Workbook(File.Contents("K:\Compliance Services\Bryon Brown\My Documents\Data\2017-2018\EndYear\CL33 - Physical Education\Final\CL33 EOY Compliance Report 10172018.xlsx"), null, true),
    #"Elem Course level_Sheet" = Source{[Item="Elem Course level",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"Elem Course level_Sheet", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Student ID", Int64.Type}, {"School DBN", type text}, {"Term Model", Int64.Type}, {"First Name", type text}, {"Last Name", type text}, {"Grade Level", type any}, {"Official Class", type text}, {"School Year", Int64.Type}, {"Term ID", Int64.Type}, {"Scheduling Method", type text}, {"Course Code", type text}, {"Section ID", Int64.Type}, {"Days per week", Int64.Type}, {"Minutes per week", Int64.Type}, {"MTI minutes per week", Int64.Type}, {"Total PE Minutes (corrected)", Int64.Type}, {"Is the school an MTI all-star? (as of 07/20/18)", type any}, {"Does the course meet requirements?", type text}})
in
    #"Changed Type"

 

Bbrown44 Regular Visitor
Regular Visitor

Re: fix query error due to excel numeric stored as text error

Learn something new everyday!!!

Thanks!