The Environment concept in M for Power Query and Power BI Desktop

Thunderstorms over the Costa Brava, Spain

The environment concept (in our opinion) is one of the most important concepts in M, while it is one of the least obvious ones. This series of posts is written in collaboration with Imke Feldmann from thebiccountant.com. Our motivation for this series is, to make this concept more popular and to show where it is needed to overcome some aparrently strange error messages. We’ll be very close to the official language specification, which you can find here. Because the official documentation is a very technical one, we’ll try to write it more understandable and add examples, where it adds value. You, as a reader, are highly encouraged to give feedback and suggestions. We’d love to have a great discussion about environments in M. Let’s go…