06-07-2022 14:08 PM - last edited 06-16-2022 11:14 AM
This Dev camp session is guest led by Alex Powers (@AlexPowers) from the Power BI CAT team. Alex will teach you how to get started with creating custom functions to aid in the reusability of transformation patterns and how to add robust documentation to your Power Query queries.
As this is a code first session, we’ll explore primitive and structured data types, implicit and explicit return values, the Power Query / M language VS Code extension and more. The information presented in this session will be applicable to all places where Power Query is found.
Campers should be familiar with creating and testing queries using Power Query. Previous experience reading and writing M code in the Advanced Editor window is helpful but not required.
Notes and Documentation for Tutorial Walkthrough -https://github.com/microsoft/pbiworkshops/tree/main/Power%20Query%20Custom%20Functions%20in%20an%20Hour
Power BI Workshops available in GitHub - https://github.com/microsoft/pbiworkshops
4:26 Session materials
5:25 Introduce the Power Query language service for VS Code
8:23 Discuss Power Query Values
15:05 Explore Custom Functions
34:40 Add documentation to our custom functions
56:43 Upcoming Sessions
Follow us on Twitter - https://twitter.com/mspowerbi
More questions? Try asking the Power BI Community @ https://community.powerbi.com/