Power BI Part 3.1 – Getting Data from Excel

About this tutorial: Video duration: 52:58 By Andrew Gould Download files here – This video shows you how to import data from Excel into a Power BI report. You’ll learn about the importance of Excel tables and range names and how to select the appropriate range to import. You’ll see how to import multiple tables […]

Microsoft Power BI: Enterprise modeling with Power BI and Azure Analysis Services – BRK3064

About this tutorial: Video duration: 1:18 Power BI and Azure Analysis Services enable you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights. We discuss the vision for enterprise BI on the Microsoft platform. We dive into the new and upcoming modeling features, such as aggregations for big data which enables interactive analysis over […]

Microsoft Power BI: Democratizing self-service data prep with dataflows – BRK3051

About this tutorial: Video duration: 1:1:38 Preparing and defining ETL for insights is a significant challenge for businesses today — ingestion, cleansing, transformation, and enrichment are labor-intensive and time-consuming tasks which require deep technical skills. Microsoft has recently introduced advanced data prep with dataflows for the Power Platform, a suite of self-service low-code/no-code features and […]

Microsoft Flow and PowerApps: Building data connectors – BRK3049

About this tutorial: Video duration: 58:56 In this session, learn all about building connectors for Microsoft PowerApps and Microsoft Flow. Connectors are essential to get you the data you want. This session provides an overview of how connectors work, outlines how you can build one, and reveals what is coming in the future. Learn some […]

Microsoft Power BI: End-to-end Power BI Desktop data modeling – BRK2078

About this tutorial: Video duration: 59:40 This session is designed to provide a complete overview of Power BI Desktop data modeling. Learn about common development methodologies, including topics on Power Query to access, prepare and load data, model relationship types, features to enhance model usability, and how to secure model data with security roles. This […]

Power BI – Power BI publisher for Excel

About this tutorial: Video duration: 4:30 Power BI – Power BI publisher for Excel

Use the Query Editor

About this tutorial: Video duration: 3:29 Learn how to use the query editor in the Power BI Desktop to clean and transform your data. Learn more at

Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula: Excel Magic Trick 1552

About this tutorial: Video duration: 22:45 Download Excel Finished Files: Entire page with all Excel Files for All Videos: In this video learn how to Average a customers last three sales (last three dates) using Excel Worksheet Formulas, Power Query M Code and a Power Pivot & Power BI DAX Measure. Learn about the Table.Sort […]

Why Does Power Query Work So Well? Automate Excel Dasbhoards without VBA – Power Query, Pivot Tables

About this tutorial: Video duration: 13:33 In this video you will learn how the structure of an Excel Dashboard using Power Query (aka Get and Transform), Tables, Pivot Tables and Pivot Charts is the secret that will enable you to build dynamic Excel Dashboards which are fully automated without having to write and Excel VBA […]

Query parameters (1-5b)

About this tutorial: Video duration: 5:48 This video is part of the Analyzing and Visualizing Data with Power BI course available on EdX. To sign up for the course, visit:

Usar Power Pivot en Excel para hacer una Tabla dinámica con información de Microsoft Access

About this tutorial: Video duration: 11:43 #Excel, #PowerPivot, #EXCELeINFO ✅ Descarga el archivo de ejemplo | ? Suscríbete a este canal | El tema de Inteligencia de negocios nos está abordando por todos lados, y Microsoft Excel ya está listo para la batalla. En este tutorial seguiremos probando la maravillosa herramienta Power Pivot. Nos conectaremos […]

Publish to web (4-6b)

About this tutorial: Video duration: 2:11 This video is part of the Analyzing and Visualizing Data with Power BI course available on EdX. To sign up for the course, visit: To read more: Power BI service Power BI Desktop Power BI basic concepts tutorial: To submit questions and comments about Power BI, please visit community.powerbi.com.

Import a custom visualization in Power BI

About this tutorial: Video duration: 2:17 How to import a custom visualization in Power BI. Link to Custom Visualization Gallery: Link to how to remove a custom visualization: Looking for a download file? Go to our Download Center: SUBSCRIBE to learn more about Power and Excel BI! Our PLAYLISTS: – Join our DAX Fridays! Series: […]

A simple and fun guide to Microsoft Flow and Power BI

About this tutorial: Video duration: 12:47 In today’s video we will demonstrate how Microsoft Flow works and how to send data to Power BI from different services. To demonstrate that, we have created a startup called StockholmICE that delivers ice creams to homes. We will monitor and store weather data to help our drivers stock […]

Walkthrough: SQL Server DirectQuery with Power BI

About this tutorial: Video duration: 7:52 I walk through using a DirectQuery connection with SQL Server and the Power BI service. I start with Power BI Desktop, show how to configure the enterprise gateway, and then show how it looks in the Power BI service. SUBSCRIBE! LET’S CONNECT! Guy in a Cube — — — […]

SAP HANA with Microsoft Power BI

About this tutorial: Video duration: 8:23 The SAP HANA connector is now available, allowing you to author reports in Power BI Desktop with a direct connection to SAP HANA. You can also publish these reports to the Power BI service to share and collaborate with others. Learn more at

Power BI Tips & Tricks #12: Build your own KPI indicators in Power BI

About this tutorial: Video duration: 8:31 Finally you can create Excel like KPIs in Power BI with this neat trick! Download the example here: Northwind data source: Icons: Keynotes: – Current KPI visuals in Power BI 00:13 – Build the KPI measure 01:12 – Create the icons from web sources 03:15 – Filter your table […]

Factura en Excel Parte 1 – Plantilla, Fórmulas y listas de validación de clientes y productos

About this tutorial: Video duration: 17:43 ✅ Descarga el archivo de ejemplo | ? Suscríbete a este canal | En esta primera parte del Proyecto Factura en Excel descargaremos una plantilla de una Factura sencilla y la formularemos para traer los datos del Cliente a facturar en base a su nombre elegido en una lista […]

Add Leading and ending zeros with Power Query #2: (M)agic (M)ondays

About this tutorial: Video duration: 8:5 In today’s tutorial, I will show you how to add leading zeros and ending zeros to your text/ number columns using Power BI and the M language. SUBSCRIBE to learn more about Power and Excel BI! Our PLAYLISTS: – Join our DAX Fridays! Series: – Power BI dashboards for […]

Avoid refresh errors when importing files in Power BI

About this tutorial: Video duration: 11:11 Have you refreshed Power BI files and got errors due to missing columns or unwanted columns? Here I show you how to avoid new columns for getting added and refresh error from missing columns. I learnt this by watching Microsoft Power BI webinar with Chris Webb: Make sure you […]