Update Power BI Desktop automatically

About this tutorial: Video duration: 4:50 In today’s video I will show you how to install power bi desktop so you get automatic downloads every time the power Bi team releases a new version. The great thing about this is that you dont need to have administrator rights on your computer to get the download. […]

Count the number of words in a text -#7 (M)agic (M)ondays with Power Query and Power BI

About this tutorial: Video duration: 11:22 In today’s video I will show you how to count the number of words in a text. Link to the post I found the solution: To do that, I will give you an example of a report I am working on. I am using Miguel Escobar youtube custom connector […]

Download/ Export Power Query data to csv, excel or txt – Power BI Tips & Tricks #25

About this tutorial: Video duration: 6:48 Do you want to export your power query data? In this video I show you how to do it 🙂 How to install R: BI accountant blog: Link to Power BI file: R script: require(gdata) write.table(trim(dataset), file=”C:/writeyourfilepathhere/filename.txt”, sep = “t”, row.names = FALSE) plot(dataset); Looking for a download file? […]

Group rows with uneven number of rows – Part 7: Power Query Challenge

About this tutorial: Video duration: 10:16 In today’s video we continue with the Power Query challenge where Collin shows us a great trick on how to group rows with uneven number of characters. What is this Power Query Challenge? Source files: Part 1: Part 2: Part 3: Part 4: Part 5: Looking for a download […]

#33 Import from PDF into Power BI Desktop

About this tutorial: Video duration: 7:49 In today’s video I will show you how to import data from a pdf file into Power BI using Imke Feldmann’s R-script. To download the file, go to Curbal’s download center and the communty downloads and get gile #33: Install R in Power BI: If you prefer to read, […]

Managing changing column names in Power Query #10: (M)agic (M)ondays

About this tutorial: Video duration: 8:46 In today’s video, I will show how to manage column headers that changes names so your power bi file does not break when you refresh it. This tip is from Lars Schreiber and here is the link to his blog post and how to do this in power query: […]

Split text by capital letters and non/digits – Power BI Desktop February Update 2019

About this tutorial: Video duration: 4:50 It took a blog post by Chris Webb for me to see this update, and maybe some of you have also missed this? There are 4 new split by options in the Power Query User Interface and we will review them here. Link to Chris blog: Here you can […]

#D49 – Add rows and columns to tables using M in power query

About this tutorial: Video duration: 6:5 In this video, I am going to show you how to add column and rows to a table in power query without appending it. Simply using the M language. #powerquery #curbal #powerbi Here you can download all the pbix file (download 49- community downloads): SUBSCRIBE to learn more about […]

Excel Magic Trick 1332: Power BI Desktop: Import Multiple Excel Files & Build Dashboard

About this tutorial: Video duration: 15:23 Download File: See how to use Power BI Desktop to Import Multiple Excel Files & Build Dashboard 1. (00:01) Introduction 2. (01:40) Download Files 3. (01:59) Download Power BI Desktop. Why would we need to do this if we have Excel? 4. (03:09) Import and transform many Excel Files […]

DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561)

About this tutorial: Video duration: 11:6 Download Excel File: Download Start Power BI Desktop: Download Finished Power BI Desktop File: Entire page with all Excel Files for All Videos: Learn how to create a DAX Calculated Colum and DAX Measure for Half Year Running Totals in Power BI Desktop or Excel Power Pivot. Topics: 1. […]

Create Power BI reports in Power BI Report Server

About this tutorial: Video duration: 9:7 Create Power BI reports in Power BI Report Server In this video, I walk through the steps to create your Power BI Report in order to publish it to Power BI Report Server. This involves downloading and installing Power BI Desktop optimized for Power BI Report Server and connecting […]

Handling errors in Power Query – Power BI Tips & Tricks #32

About this tutorial: Video duration: 7:35 Have you ever got errors in Power Query and you dont know how to manage them? In today’s tutorials I will show you how to: Delete errors in Power Query or Expand the list without removing them, allowing you to filter them out. Link to Power BI file: Looking […]

Getting started with Power BI and SharePoint Online

About this tutorial: Video duration: 20:31 In this video we get an introduction to using Power BI with SharePoint Online list data. Pretty exciting stuff. We start at the beginning of installing Power BI Desktop and don’t stop until you have a report published to SharePoint Online using the preview web part. Even better is […]

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

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:

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.

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 […]

Import Power Pivot Data Model into Power BI Desktop (Excel Magic Trick 1365)

About this tutorial: Video duration: 3:36 Download File: See how to import an Excel Power Pivot Data Model with tables, relationships and DAX Measures into Power BI Desktop using the File (Upper Left icon), Import, Excel Workbook option in Power BI Desktop. Incoming search terms:mike girvin from power query to power bi magic trick

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 […]