Power BI Service failes refreshing Azure Data Lake Store data source with not being able to covert

There were two things that needed to happen to get this to work.

First, there needed to be a service account without two factor auth that's used as the credentials for the data set.

Second I had to change the M query from what the Power BI desktop created

let
    Source = DataLake.Contents("adl://<full path>", [PageSize=null]),
    #"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File from Query1 (2)", each #"Transform File from Query1 (2)"([Content])),
    #"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1", {"Transform File from Query1 (2)"}),
    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File from Query1 (2)", Table.ColumnNames(#"Transform File from Query1 (2)"(#"Sample File (2)"))),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Column1", type text}, {"Column2", type text}, {"Column3", type datetime}, {"Column4", type number}, {"Column5", type number}, {"Column6", type datetime}, {"Column7", Int64.Type}})
in
    #"Changed Type"

to

let
    Source = DataLake.Contents("adl://<path to folder>"),
    #"File1" = Source{[Name="<file>.tab"]}[Content],
    #"Imported CSV" = Csv.Document(File1,[Delimiter="#(tab)", Encoding=1252]),
    #"Changed Type" = Table.TransformColumnTypes(#"Imported CSV",{{"Column3", type datetime}, {"Column4", type number}, {"Column5", type number}, {"Column6", type datetime}, {"Column7", Int64.Type}})
in
    #"Changed Type"