Let give super power to your Power Query with a bunch of M code.
Power Query has always been a central component of the data modeling process in Power BI. Today, with the advent of Fabric and Dataflows Gen 2, Power Query stands as the primary ETL tool for any modern data warehousing project in Azure. Thanks to its graphical interface, we have at our disposal a lot of functionality to turn any data source, even the most stubborn, into a part of our data model.
But have you ever wondered what Power Query could become by adding to its enormous potential, a dash of imagination and a handful of M-code?
Boost your Power Query skill learning a bunch of tips and tricks.