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.
For the past two years, my team has been working on a premium Power BI model that has grown significantly in size, from 50 GB to over 100 GB. During this time, we have gained valuable insights and lessons that we would like to share with you. These include the importance of conducting systematic testing, determining which features and columns will have the most impact on performance, and managing the ongoing refresh of a model of this size. We hope that these tips will be helpful for those looking to optimize and improve their Power BI models.
Alex Dupler is a Power BI developer and architect at Microsoft, where he currently serves as the lead Program Manager for a data warehouse platform supporting the company's advertising business. In this role, Alex is responsible for a Power BI import dataset with 90 GB of data. He is also one half of "Two Alex's," a YouTube channel that features live discussions on Power BI topics without one correct answer. Prior to joining Microsoft, Alex worked as a chemist. He is a member of the PBICAT team and has been inactive for a while.
Do you have a lot of reports but are still searching for answers? Do you really know what you are working toward? If so, we need to talk about Power BI Goals and how they can transform how you approach the question, where are we?
Treb Gatte is a business intelligence expert with 24 years of experience. Prior to becoming CEO of Marquee Insights, he worked in leadership positions at Microsoft, Starbucks, and Wachovia (now Wells Fargo). He is a Microsoft Data Platform MVP and former Office MVP. Treb lives in the Seattle area with his wife, children and corgi and holds an MBA from Wake Forest University.
The Data God Guide to Power BI Gen2 walks through what is Premium, Gen2, Strategies, and demos of implementation.
Chris Wagner, MBA | Microsoft MVP Analytics Architect, Microsoft Data Platform MVP, Data God, and Power BI Boss Chris has been working in the Data and Analytics space for nearly 20 years. Chris has dedicated his professional career to making data and information accessible to the masses. A significant component in making data available is continually learning new things and teaching others from these experiences. To help people keep up with this ever-changing landscape, Chris frequently posts on LinkedIn and to this blog.
Chris's LinkedIn
KratosBI's Twitter
Chris's YouTube
Data God's Website
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.
