4 uk
21-22 March, 2024

Days of Knowledge UK 2024

Days of Knowledge is a Directions for Partners event focused on educating consultants and developers, sharing knowledge and upgrading Business Central professionals to enable quality customer solutions. Training and acquiring knowledge are the magic words at Days of Knowledge.

21-03-2024

Automate data ingestion in Power BI with custom Power Query functions

10:00 - 11:30 Screen 11 Back to event schedule

Have you ever needed to ingest a number of same-structured inputs into your Power BI report and repeat the refresh periodically? If so, then it seems like a perfect use-case for automation using custom-made Power Query functions. You might have already tried authoring such a function, as Power Query is often able to generate the whole thing automatically, in a user-friendly way.  But what do you do if you need to handle a more complex scenario, include multiple inputs as arguments of the function or something has just stopped working and you're unsure how to fix it? During this session you will learn the Power Query custom functions from A to Z. I will first show you how to identify a good use-case for this feature. Further into the session, you will learn how to create such functions from scratch as well as what are their semantics and components. I will explain how to effectively work with custom functions and debug them over a number of use-cases. You will also learn a number of common pitfalls and bad practices to avoid. After this session you will be able to: - recognize use-cases for automation using Power Query custom functions. - create custom functions to handle complex scenarios. - debug and optimize custom functions. It would be great if prior to this session you have some experience working with Power Query and basic transformations within it.

Speakers:

Grzegorz Strzyminski

Power BI Consultant & Trainer, Senior BI Developer at Kearney

Grzegorz (feel free to call him Greg) is a Senior BI Developer at Kearney Warsaw. He serves as a Power BI technical Team Lead for the Business Intelligence team in Poland. He has proved his lecturing and teaching skills by running Power BI community events as well as internal trainings at Kearney at all levels, ranging in audience size from 5 to 250. Greg has been leading a number of Power BI workshops aimed at experienced professionals, students as well people willing to explore the art of possible in Business Intelligence. He has experience at conveying his knowledge at various levels, ranging from beginner to expert. Greg holds a number of Microsoft Certifications including Power BI - related ones: PL-300, DA-100 and 70-778.