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

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

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

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

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

Learning resources for Power BI

About this tutorial: Video duration: 7:17 link to resources: SUBSCRIBE to learn more about Power and Excel BI! Our PLAYLISTS: – Join our DAX Fridays! Series: – Power BI dashboards for beginners: – Power BI Tips & Tricks: – Power Bi and Google Analytics: ABOUT CURBAL: Website: Contact us: ▼▼▼▼▼▼▼▼▼▼ If you feel that any […]

Create an excel survey and view results live with Power BI Desktop – Power BI Tips & Tricks #09:

About this tutorial: Video duration: 9:1 In this video we show you how to create a survey using Excel and OneDrive, how to import the survey results from OneDrive to Power Bi to visualize the results. Keynotes: Create an excel survey from OneDrive 00:40 Import the results into Power BI from OneDrive 03:15 Create a […]

Power BI Tips & Tricks #02: Create a custom calendar in Power BI

About this tutorial: Video duration: 8:42 Here I show you how to create a custom calendar in Power BI. Download the calendar file: SUBSCRIBE to learn more about Power and Excel BI! Our PLAYLISTS: – Join our DAX Fridays! Series: – Power BI dashboards for beginners: – Power BI Tips & Tricks: – Power Bi […]

Power BI Announcements from MS Data Insights Summit comming this Autumn 2017 -#5 One2Many Series

About this tutorial: Video duration: 12:26 In today’s video, we will talk about all the exciting announcements made by Microsoft during the MS Data Insight Summit. Here they are if you want to skip right to them: 00:55 New Licensing model 01:42 Power BI Lite idea: 02:32 Power BI on premise generally available NEW FEATURES […]

Power BI Tips & Tricks #06: Publish your Power BI reports on the web

About this tutorial: Video duration: 2:48 Publish, or share or embed your Power BI reports on the web, email or social media. Really easy! SUBSCRIBE to learn more about Power and Excel BI! Our PLAYLISTS: – Join our DAX Fridays! Series: – Power BI dashboards for beginners: – Power BI Tips & Tricks: – Power […]

Power BI Tips & Tricks #13: Embed Power BI reports in PowerPoint

About this tutorial: Video duration: 3:12 Learn how to embed or insert power BI reports in PowerPoint! SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: – Join our DAX Fridays! Series: https://goo.gl/FtUWUX – Power BI dashboards for beginners: https://goo.gl/9YzyDP – Power BI Tips & Tricks: https://goo.gl/H6kUbP – Power Bi and Google […]