Power BI
Refreshing a Power BI Custom Connector in the Cloud
These are GREAT news! Finally we have a way to refresh data from custom connectors on the Power BI service. Surprise! You can now refresh custom connectors through the Power BI personal gateway (requires April 2018 version) https://t.co/SUF4CEuQBA#pqsdk — Matt Masson (@mattmasson) April 22, 2018
Read full article >The Navigation Step in Power Query and Power BI – Navigating to rows, columns and cells
What is a “Navigation” step in Power Query? When using Power Query, you might’ve come across a step that reads “Navigation” and is usually automatically created for you by Power Query, but…what does it do? Well, if we look at the code that it was created for the Navigation step, it reads: = Source{[Item=”SalesTable”,Kind=”Table”]}[Data] It […]
Read full article >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 >Power BI Custom Connectors multi-language support
Power BI Custom Connectors are something amazing and while they are still in a public preview phase, there are many things that are specific to custom connectors that go beyond what we used to know about M code. This post tries to cover how you can make your custom connector have a UI based on […]
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 >