Power BI Desktop – Integração com SharePoint

About this tutorial: Video duration: 13:48 Este vídeo, apresentado por nossa colaboradora de conteúdo Flavia Gomes, mostra como você pode integrar perfeitamente os seus dados existentes no Power BI Desktop com o seu ambiente corporativo do SharePoint. Veja o que você vai aprender: – Consumir uma lista do SharePoint no Power BI; – Criar um […]

Excel Magic Trick 1442 DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In List 2

About this tutorial: Video duration: 8:54 In this video see how to use the EXCEPT DAX Function & Excel Existing Connections Edit DAX feature to Extract Items in List 1 that are NOT in List 2. Download File: Start File: Finished File: Entire page with all Excel Files for All Videos: Related Videos for Comparing […]

Create a custom 4-4-5 calendar that self-generates in Power BI – Power BI Tips & Tricks 23

About this tutorial: Video duration: 22:58 A Power BI template to generate and self configure custom Power BI calendar. In this video we will show you how to create (or download mine) a custom Power BI calendar that self configures and self generates with a little input from the user. When a user opens the […]

PowerBi Monthly Report – How to make a Monthly report in PowerBi Desktop – tutorial for beginners

About this tutorial: Video duration: 2:13 PowerBi Monthly Report – How to make a Monthly report in PowerBi Desktop – tutorial for beginners Please subscribe to my channel Tom Fragale Microsoft Certified Trainer Microsoft Certified Office Master Available for Onsite Training, Private Webinars, Consulting, and Custom Software (215)280-1073 tomfragale@gmail.com To get the sample file from […]

What Is Power BI? | Introduction To Microsoft Power BI | Power BI Training | Edureka

About this tutorial: Video duration: 24:31 ( Power BI Training – ) This Edureka “What Is Power BI?” video will help you an introduction to Power BI. This video helps you to learn following topics: 1. Why Power BI? 2. What Is Power BI? 3. Who Use Power BI? 4. Components Of Power BI 5. […]

Power BI Tutorial For Beginners | Power BI Tutorial | Power BI Demo | Power BI Training | Edureka

About this tutorial: Video duration: 29:56 ( Power BI Training – ) This Edureka videoon “Power BI Tutorial” will provide you with the fundamental knowledge on Power BI (Blog: Below are the topics covered in this tutorial: 1. Why do we need Business Intelligence? 2. What is Self Service Business Intelligence? 3. Why Power BI? […]

Drilling into drillthrough in Power BI Desktop

About this tutorial: Video duration: 6:11 In this video, Patrick looks at how you can use the drillthrough feature within Power BI Desktop. He also looks at how you can drill to multiple fields at the same time. The back image can also be changed and Patrick shows you how to do it! LET’S CONNECT! […]

Using Query Functions to Populate a Single Table from Multiple Sources

About this tutorial: Video duration: 6:57 This video demonstrates using query functions (aka function queries) in a Power BI Desktop project to automate extracting NFL player data from 32 different public websites and appending all rows to a single table.

Reports vs Dashboards – (1.18) Ultimate Beginners Guide to Power BI

About this tutorial: Video duration: 9:7 DOWNLOAD RESOURCES HERE – START FROM THE BEGINNING – Follow along to the beginners guide Power BI tutorials by using the demo data available for download. Enjoy! Details of what you will learn during these Power BI course modules & tutorials Learn – how to use Power BI as […]

Dynamic Power BI reports using Parameters

About this tutorial: Video duration: 12:21 In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable […]

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