Automatically detect data type

Syndicate_Admin · ‎03-18-2023

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 · ‎03-18-2023

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Syndicate_Admin · ‎03-20-2023

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?