Automatically detect data type

[Syndicate_Admin]

Good afternoon
I have a code to load Excel tables with a path parameter to be dynamic but being dynamic and being able to load different tables the detection of data types does not do it correctly only if you manually selected the columns and change it could you help me make an m code for this? Thank you

[Greg_Deckler]

@Syndicate_Admin Try this: Automatic Detection of Column Types in #PowerQuery - DataChant

[Syndicate_Admin]

Thank you very much for the answer but I do not know how to apply it because it asks me for the name of the table and auque I indicate it I get the following error: Unexpected error in the query 'FnDetectAndTransformTypes'. Expression.Error: The import SourceTable matches no exports. Did you miss a module reference?