Power Query: Tips and Tricks | Get ResponsLIVE
Within Power BI the component Power Query is often undervalued. Maybe people find it too technical? But … when used right it can be a very powerful part of automating your dashboards. Imke Feldmann is an expert in Power Query. And this week she is our guest in Get ResponsLIVE Ep 103. She will share tips and tricks to get (much) more out of Power Query. More re-use of your data transformations, more functionality and more performance.
0:00 Introduction GRLive
1:45 Introduction of Imke Feldmann
3:29 How Imke started sharing her knowledge 7(!) years ago via the BIccountant (https://www.thebiccountant.com/)
5:25 What is Power Query and where do you use it for?
6:44 Introduction in steps in Power Query
7:37 The Power of using M
9:09 How to load data from Github
11:15 How your steps are converted into code
11:58 Easily use your M code in Excel
13:31 How to copy multiple queries from Power BI to Excel via Power Query
14:50 Difference between Excel en Power BI Power Query
15:40 Alternative to Power Query: Power BI Data Flows ("Power Query in the cloud")
16:10 Easily copy in 2 clicks multiple queries from Power Query to Data Flows
18:55 Using Data Flows and performance implications versus Power Query
19:53 Analyse (all) your Query code
21:34 Getting help on Power Query via Microsoft Community
23:23 Applying a solution (code) in your own Power Query
26:25 Viewer question from Azouaou: referring to prior Row in Power Query
27:18 Answer: there is a function for that and how to apply
29:31 The new DAX Offset function
30:10 Very cool example of using a Custom made function for complex unpivot
32:55 Introduction into M Extensions
34:25 In Roadmap: create personal query/function collection
35:40 M repository of functions in github of Imke: https://github.com/ImkeF/M/tree/maste...
36:42 How to navigate wide tables and find columns
41:10 Performance Tip 1: Improve Pivoting performance
44:07 Performance Tip 2: How to improve Merge performance
49:15 More performance tips on the BIAccountant: https://www.thebiccountant.com/speedp...
49:53 Closing and invitation to Imke to come back! :-)
Get ResponsLive is live every Thursday at 4:00 PM. If you sign up, LinkedIn will notify you as soon as we go live. Or watch us on Youtube!
We are here everyThursday at 4.00 PM with a new episode. And you can rewatch them all on our YouTube channel: Get Responsive, where more than 800 Power BI fans now follow us. On to the 1,000!
Great that you’re watching!
Sign up for our channel to see more valuable video’s: https://bit.ly/2C0PWUH
**
You can find all previous episodes (and also those after the Live session) via our website and YouTube channel.
Do you want to learn more about power BI and the Power Platform itself?
You can now learn everything about Power BI in your own time with our new learning platform Power Up. From beginning to Advanced. For more information: //bit.ly/powerup-yt-22
Website: www.get-responsive.com
LinkedIn: / get-r. .
Facebook: / getresponsive
Would you also like to tell us something nice or share your dashboard with us? Then visit our website and send us a message.
#powerbi #Powerquery #datagedreven #PowerBI