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

CĂłmo crear un gráfico de velocĂ­metro en Excel – Dashboards Tips

About this tutorial: Video duration: 11:3 âś… Descarga el archivo de ejemplo | 🏆 SuscrĂ­bete a este canal | đź“© Recibe tutoriales en tu correo: En este video tutorial te mostrarĂ© cĂłmo crear un gráfico de velocĂ­metro desde cero en Excel y lo puedas implementar en tus Dashboards e informes. Muchos ejemplos | Muchos ejemplos […]

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

Curso Excel VBA y Macros – Cap. 24 – Bucles Do…Loop, Do…While y Do…Until para repetir macros

About this tutorial: Video duration: 20:40 âś… Descarga el archivo de ejemplo | 🏆 SuscrĂ­bete a este canal | đź“© Recibe tutoriales en tu correo: đź’Ż Compra Office 365 de manera segura en la Microsoft Store En este tutorial veremos algunos temas interesantes, sobre todo conceptos que son muy importantes de entender si deseamos volvernos […]

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

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

DAX Fridays! #95: Binning, Frequency and relative frequency | Data profiler

About this tutorial: Video duration: 17: This is the first of a series of videos about data profiling and descriptive statistics. In today’s video, I will show you how to bin data, calculate the frequency and relative frequency using DAX. What you think about the series? let me know in the comment box. Download file […]

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

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

Copiar, mover, eliminar y renombrar archivos y carpetas desde Excel con VBA y macros @EXCELeINFO

About this tutorial: Video duration: 23:29 âś… Descarga el archivo de ejemplo | ? SuscrĂ­bete a este canal | Cuando trabajas con macros en Excel, en algĂşn momento de tu vida será necesario administrar archivos desde tus propias macros y para eso será necesario que tengas a la mano las instrucciones necesarias para realizar acciones […]

Cambiar a MayĂşsculas, minĂşsculas y Nombre Propio – FĂłrmulas y VBA en Excel @EXCELeINFO

About this tutorial: Video duration: 14:1 âś… Descarga el archivo de ejemplo | ? SuscrĂ­bete a este canal | En este tutorial veremos la manera de convertir valores de un rango de celdas en mayĂşsculas, minĂşsculas y nombre propio. Lo haremos tanto como fĂłrmulas en Excel como con lenguaje VBA y macros. Funciones de texto […]

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