Summary
How to convert data types to text in Power Query M, for example for error messages that show the problem type.
Deepen your knowledge
Knowledge Base
What is Power BI? Everything you need to know
Discover what Microsoft Power BI is, how it works, what it costs, and why it's the world's most popular BI tool. Complet...
Knowledge BaseETL Explained — Extract, Transform, Load in plain language
What is ETL? Learn how Extract, Transform, and Load works, the difference with ELT, and which tools to use. Clearly expl...
Related articles
How to Replace Multiple Substrings in Power Query M
Technique to replace multiple substrings at once in Power Query M, beyond the limitations of Text.Replace.
Convert RGB to HEX in Power Query M
Convert RGB values to HEX color codes in Power Query M so you can assign colors programmatically in Power BI.
Creating a 445 Calendar (incl 454, 544) in Power Query M
Create a 445 calendar (including 454 and 544) in Power Query M with weeks, periods, and quarterly calculations.
Enter Data in Power Query M: From Table to Binary and Back
Technique to convert data between table format and compressed binary strings in Power Query M via Enter Data.