Extracting SQL Database/Table Names From Your Power BI Dataset!

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.

RELATED CONTENT 🔗

Extracting All M-Code from a Power BI Dataset

(Livestream Replay) Design Scalable BI Solutions with BI Solution Algebra - with Chris Wagner

DESCRIPTION 📄

Join Chris Wagner and Reid Havens as they talk about BI Solution Algebra, a framework for designing business intelligence solutions that are scalable, efficient, and cost-effective. They will share their insights and tips on how to choose the right mix of front-end, model, ETL, and other components to optimize your data analytics efforts. Whether you are a beginner or an expert, you will learn something new and useful from this lively and engaging conversation. Don’t miss this opportunity to learn from two of the best in the field!

GUEST BIO 👤

Christopher Wagner is a passionate data evangelist and a leader in data solutions. He is the Director of Data Solutions for Baker Tilly, a leading digital solutions, advisory, tax and assurance firm. He is also the founder of KratosBI.com, a website that provides resources, tutorials and insights on data and analytics. He hosts the Data Gods YouTube channel, where he shares his knowledge and experience with data enthusiasts and professionals.

Christopher has over two decades of experience in the data and analytics field, working with various technologies, platforms and tools. He has helped many organizations transform their data into valuable insights and actionable outcomes. He believes that data is the most powerful asset in the digital age, and he strives to make it accessible and understandable to everyone.

RELATED CONTENT 🔗

Website
YouTube
LinkedIn
X (Twitter)
Engagement

Starter Extensions for Visual Studio Code and Power BI (with Štěpán Rešl)

Video by: Reid Havens

Learn about a good starter pack list of extensions (plug-ins) for Visual Studio Code (VS Code). These extensions will be useful for: data modelling (DAX, Power Query), Git Management, Power BI administration, SVG/XML/Java scripting, custom visual development, and more! Tune in to find out.

GUEST BIO 👤

"Don't say something cannot be done, or someone who doesn't know will come and do it.". This motto describes me very well. I would say because I am trying to find a path even on fields where paths shouldn't be. I'm the MVP of Data Platform (Power BI) and a co-founder of a company called DataBrothers, where I work as a Lead technical consultant. Primarily I am working with Microsoft Power Platform Technologies (Power BI, Flow / Automate, and PowerApps) and am the Author of the Czech PBI blog Jakna Power BI (translated "How to Power BI").

RELATED CONTENT 🔗

Štěpán's LinkedIn
reporTee (Power BI guided learning)

(Livestream Replay) Data Warehousing with Microsoft Fabric - with Andy Cutler

DESCRIPTION 📄

With the introduction of Microsoft Fabric in 2023, the scope of data workloads available has expanded to include Power BI, Lakehouse, Warehouse, and Real-time Streaming. In this session we'll be diving into one of the workloads that Fabric offers, Data Warehousing. We'll cover a quick introduction to Fabric with a discussion on lakehouse vs warehouse. Then we'll dive into the SQL engine and look at how to create a Warehouse including objects like tables and stored procedures. We'll then look at how to load warehouses using SQL and Pipelines.

GUEST BIO 👤

Andy Cutler is an independent consultant specialising in the Azure Data Platform, working predominantly with Azure Synapse Analytics, Data Factory, SQL Server and Power BI. He holds an MSc in Business Intelligence and Data Mining, and is a current Microsoft Data Platform MVP.

RELATED CONTENT 🔗

LinkedIn
Blog
Company
YouTube

Posted on September 1, 2023 and filed under Livestreams, Fabric.