Skip to main content

Power BI

New

Highlight "type any" data types in a different colour for an easier spot

Vote (1) Share
Javier Cuesta's profile image

Javier Cuesta on 06 Oct 2021 08:02:17

I use the "detect data" type a lot, but also PQ applies data type to columns by default following some query steps (in both Desktop and Online). To avoid further steps and keep a cleaner code, I try to change the type in the formula bar when PQ doesn't manage to get the data type so it applies "any" type.

So I try to spot those in the code and change them according to my knowledge or just to text if unknown.

To have those "any" coloured in a different "way" to "text" or "date" would be super handy to work upon the code as they would be easily spotted.

This is especially important now I'm working on PQ online, working with dataflow, as it doesn't allow non-typed columns. (Online PQ interface has some different features that are making me work more online in the last times ("profile columns based on the entire dataset" and the "Schema view").

Thank you.