Havens Consulting
Video by: Reid Havens
Learn how to query the XMLA end-point in a Premium (Per User or Capacity) workspace to extract all the Power Query M Code, and parse out your SQL Database names, table, names, and parameters from your queries. Tune in to learn more.
The reality is folks need / want their data in Excel at some point. While Power BI reduces that need, it still exists. Wyn’s demos will show how to connect using various approaches including a trick to create a connected table with the help of “create formatted table” feature of Power BI, and the largely unknown Featured Table option.
Wyn Hopkins is a Microsoft MVP, trainer, consultant and author of the book “Power BI for the Excel Analyst”
Based in Perth, Western Australia, Wyn is the director of the Power BI and Excel consulting firm “Access Analytic”. Their YouTube channel has 40,000+ subscribers and he co-runs the Perth Power BI and Modern Excel meetup group. Once upon a time Wyn was a chartered Accountant with PriceWaterhouseCoopers but Wyn and team now spend their time delivering Power BI and Excel training along with reporting solutions for clients of all industries and sizes. Wyn’s claim to fame is that he suggested and campaigned for the creation of the XLOOKUP function.
Wyn's Book & Website
Wyn's Company Website
Wyn's Social Media Links
Join Heidi Hastings and I as we dissect everything about sensitivity labels! Such as what they are, how they're used, why they're important, where to find them, and more! You'll also see what they look like in Power BI, Purview, Excel, Azure SQL, and other locations!
Heidi Hasting is a Business Intelligence professional and former software developer with over eight years experience in Microsoft products. She is an ALM/DLM enthusiast and Azure DevOps fan and co-founder and organizer of the Adelaide Power BI User Group. Heidi is a regular attendee at tech events including Azure Bootcamps, DevOps days, SQLSaturdays, Difinity and PASS Summit.
Once you have built a Power BI dataset there are several options for displaying the data in it: classic Power BI reports, paginated reports and Excel. This session is all about the third option, Excel. You’ll learn how to connect Excel to a Power BI dataset and use PivotTables, Excel cube functions and the new Excel data types to build reports. You’ll also get a sneak preview of upcoming functionality which allows your Power BI-connected Excel reports to work in the browser and not just in Excel on the desktop.
Chris Webb works on the Power BI CAT team at Microsoft. He has been using Microsoft BI tools for over 20 years, speaks regularly at user groups and conferences and has written several books on Analysis Services and Power Query.
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
