Power Query
Query Error Auditing in Power Query for Excel and Power BI
As any other programming language, Power Query handles errors in its own unique way and the goal of this blog post is to give you a few hints on how to audit the errors or warnings that Power Query might throw your way. Types of Errors Power Query primarily handles 2 types or categories of […]
Read full article >
Data Types, Data Conversion and Ascribed Data Types in Power Query and Power BI
As we saw in a previous post, there are many things that we need to consider when dealing with Excel files since even the extension of an Excel file can dramatically impact your solution and how Power Query interprets the contents of that file. In a more broader sense, we also need to take in […]
Read full article >
Calculate Days between dates using Power Query / Power BI
Have you ever wanted to find out how many days you have between 2 dates? perhaps how many Mondays? how many Sundays? perhaps Saturdays and Sundays? Well, in this blog post I’ll show you how you can do that with Power Query inside of Excel and/or Power BI and how you can extend this to […]
Read full article >
Recurring dates with offset in Power Query
Imagine this scenario, you are a Doctor who has multiple appointments with patients on a daily basis. Sometimes, you need to schedule follow up appointments with your patients just to make sure that everything is going according to plan and basically do a check up. You record these appointments in a simple spreadsheet like the […]
Read full article >
Power BI / Power Query and Excel files–XLSX vs XLS formats and datatypes
This is a topic that has been previously covered here by my good friend Ken Puls, but it was just recently that I found this response from Ehren about how Power Query interprets xls files differently to xlsx files and it is certainly worth a blog post to cover this in more detail. I highly […]
Read full article >
Guide and Resources for Web Data Extraction with Power BI & Power Query
With the recent release of the Power Query Extensibility Model or Power BI Custom Connectors, I’ve been thinking about posting an article about the status of Web Scraping with Power BI / Power Query, its limitations and how Custom Connectors are here to provide the functionality that was restricted or limited to us within Power […]
Read full article >
The Ultimate Calendar Table Creator for Power BI
Power Query and Power Pivot are AMAZING tools, but if you want to create a Calendar Table with either one of them, you’ll either have to learn how to code in M or DAX, or copy/paste a code that you probably found on the web like this one. The problem with that is that every […]
Read full article >
Connecting to APIs with Power BI (Power Query)–Part 1 of 2
Why is it so complex to connect to an API with Power BI or Power Query? The OAuth explained It’s easier to explain using analogies, so let’s go with that! Analogy: Imagine that you have a gym subscription and this gym also has a VIP lounge, but to get to the lounge you need to […]
Read full article >
Advanced Power Query and other questions from ‘M is for Data Monkey’ readers
The #1 Power Query book in sales and ratings. THANK YOU everyone A little over a year ago, Ken Puls and I published a book called ‘M is for Data Monkey’ which came out from a cycle of iterations over our Live Online Workshop. The book, in essence, is a summarized version of our Workshop […]
Read full article >ABC Analysis with Power Query
After an amazing first Power Query workshop in English, we are providing our attendees with even more CRAZY cool content that they’ll be able to put into practice (and understand) right away! You might have already seen an ABC Classification Pattern with Power Pivot here, but this time you’re going to see this pattern being […]
Read full article >Power Query for Excel – Replace values using values from another column
Another video trick for Power Query. A glimpse of how advanced you can go with Power Query using custom M code. Be sure to check out more tips and tricks like this one on the oficial Power Query Training page
Read full article >Getting Started & Understanding Power Query and the M Language
Let’s put Power Query and the M Language under the scope Power Query is a breakthrough tool for self-service Business Intelligence and it’s the new best tool released by Microsoft within the span of 5 years. I’ve already posted about what Power Query is and what it represent to us but, How can I get […]
Read full article >