Blog Post

Power BI Community Blog
2 MIN READ

Dynamically Detect Column Types with Power M

stevedep's avatar
stevedep
Memorable Member
5 years ago
The below Power M function will take a table as a parameter and return a table where the data types have been set.   Please mind, it currently only works for the datatypes; datetime, date, number...
Updated 5 years ago
Version 3.0
how to
tips & tricks
stevedep's avatar
Memorable Member
Joined December 25, 2015
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
sysmod's avatar
sysmod
New Member
4 years ago

stevedep 

Could you post a modified function that only detects the data types rather than transforming them as well? It would be nice to have an InferDataTypes function that returns a table of field names, data types, and count of records matching the found data type. Similar to Table.Schema and Table.Profile.

Thanks!

Patrick