In this Power BI Tutorial, Adam shows how you can easily work with JSON data within Power BI. Working with JSON data in Power BI Desktop is one of the best-kept secrets of Power BI.

Use email attachments as a data source for Power BI

Recently I found a PowerQuery gem, trick with Java/VB Script that allows to export data from Power Query to CSV without R / DAX Studio / SMS and Registration. However, related with risk. As everyth…

There are times where you need an efficient way to produce all unique combinations of your data. Recently a customer of mine used a report to track how the sales were doing. Their situation is as follows. The company reports several metrics for their business units. And not only that....

In this article I'll show how my classic method of Creating Dynamic Parameters in Power Query can be modified to display them as "Real" Parameters.

Learn how to create grouped serial numbers for your data in power query

Recently, I had to import a large-ish CSV file at around 1.5 million rows into Excel using Power Query. I used a From Text/CSV query but then I tried to export a new set of data with a longer timeline. In this post, we'll look at how we can convert a From Text/CSV query into a From Folder query.

I worked most of my career as an actuary at various insurance companies. Most of the time they had systems that were built before I was born, so I spent a good portion of time getting and transforming…

New Data Types in Excel will undoubtedly be THE talking point of the near future Excel evolution. That being said, they are also the reality in Office 365 Fast Insiders. That’s where they were recently introduced by Microsoft. This post will first explain what the new Data Types in Excel are and then we will […]

In this post, we’re going to talk about importing CSV files with power query! This is a guest post written by John MacDougall, an Excel MVP from Canada. John runs a famous Excel blog called How To Exc…

About two years ago I wrote a blog post describing how the #table M function can be used to generate tables, but in that post I only covered the functionality I used regularly – namely using #table wi…

A quick walkthrough on how to import multiple SharePoint lists at once, like with the import from folder method on ordinary files.

In this week’s blog post, I created this Power Query Pattern, which I created to add in spaces for CamelCase text within a column. To get this to work for you, all that you do is need to make…

The results are in! Let’s find out which tool is better for the average Business Analyst based on the 3 scenarios that I showcased a few weeks ago here. I was able to get in touch with the Product Team from Microsoft’s Power Query and also the one from Trifacta’s Wrangler. I tried getting in …

Being a fan of PowerBI, I recently looked for a way to read zip files directly into the Data Model, and found this blog which showed a usab...

Get Data from the Twitter API with Power Query. Power Query can perform HTTP GET & POST, making it very useful for working with REST APIs.

Thoughts on data analysis, programming, and statistics, with an emphasis on R, JavaScript, Power Query, Azure, and Power BI

Introduction to PowerTweet M functions

Let M write its own code: Automatically create a function record for Expression.Evaluate to replace #shared so it will work in the service as well.

Recently I needed to do the very simple thing in Power Query. I have the column of numbers and need to check if the values in this column are less than N and then put a corresponding text value in the new column. The function for the new column is something like this: Actually some values are not a numbers but nulls: Data contains nulls and comparison return an error And this simple calculation returns an error for these values! Why? There is the catch, which is hidden in the depth of documentation (actually on the page 67 of the "Power Query Formula Language Specification (October 2016)" P...

Sometimes your power queries can get quite heavy and you might need to optimize the steps in your query but how can you calculate the time it takes for your query to load. Wouldn't it be nice if you c…

I was working on a dataset where I wanted to change multiple column names using one step and not having to change them manually. Since there were over 30 columns this would be really time consuming…

Working with column types can be challenging in Power Query. The default conversion of types may not always work well for you, and may create future refresh errors, when the column names change. I have blogged about it in details here, and usually recommend to use explicit type conversion, and remove the automatic Changed Type detection …

The latest version of Power BI Desktop came out with a new Web Connector specifically designed for Web Scraping Scenarios. in this blog post I’ll try to go deep into how this new experience works and how you can take advantage of it. Before we move forward, you’re gonna need the latest version of Power …

The good folks from SumProduct have published a challenge for Excel that I find worth doing in Power Query instead: The Challenge Stretching or compressing a forecast so that the proportion of (…) Read more

See how cool it is to build a permutations table with Power Query. Being able to see the results of each of your steps immediately makes a real difference h

What an amazing year 2018 has started out to be! Joining the PowerPivotPro team was an aspiration of mine that started in the Fall of 2013… I wanted to BE a part of this team and this community – to be able to share what I have personally experienced and what I have learned about using PowerPivot In Excel and Power