Blog

Categories: AnnouncementsPower PivotPower QueryPower BI

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

Power BI Power Query
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 […]

Power BI Power Query
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 […]

Power BI Power Query
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 […]

Power BI Power Query
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 […]

Power BI Power Query
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 […]

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

Power BI Power Query
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 […]

Power BI Power Query
Read full article >

Free WideWorldImporters Access Database and New Power BI Video Tutorials

This is a short a blog post to let you know that there’s a bunch of new resources that have been published lately and we’re keeping things rolling over here. Today we’re making putting this WideWorldImporters database (Access version) publicly available so everyone who hasn’t tested the full SQL Server WideWorldImporters database yet can try […]

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

Power BI Power Query
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 […]

Power BI Power Query
Read full article >

Announcements: Power BI Red Carpet Program + New Power Query book is out!

Power BI now in Panama! Powered Solutions is now part of the Power BI Red Carpet Program The Power BI Red Carpet Program is an invitation-only Microsoft Program for a few selected partners worldwide and Powered Solutions has now been nominated, selected and activated as the very first and only Microsoft partner to join this […]

Announcements
Read full article >