Search
Generic filters

Power Query

Power Query

Use Power Query Builder to Cut Power BI Development Time

Power Query Builder is a great tool inside of Power BI. In this post I’d like to discuss using the Power Query Builder to help leverage Power BI against your Power Apps databases, including Dynamics 365, both CRM and financials databases, or any data house in the Common Data Service...

Read more

Working with a JSON Array in Power Query

Update 2016-04-27:  Imke Feldmann sent me an M query that accomplishes the same goal of this post with less than half the code! The query is here. Imke’s blog is a great resource and you can also find her on Twitter. Thank you, Imke! Basic JSON structures can be parsed pretty...

Read more

Install Power Query With Excel 2013

Power Query is a new add-in that was introduced in Excel 2013 by Microsoft and was that popular that they made it backward compatible with Excel 2010. Read the tutorial on how to install Power Query in Excel 2010 here Well you know when you get data from a file, a data...

Read more

Nuthin’ ain’t nuthin’ in Power Query

There are two kinds of nuthin' in Power Query: null, and blank. I tripped on this issue the other day, and Ken thought it would be a good idea for a blog post. Let's just call out the two types of nuthin' in Power Query: null is literally "no value" for...

Read more

Query Dependency View in Power BI Desktop

I have been on holidays taking a much needed break from work, so it has been very quite on my blog over the last few weeks.  But I am back now! I woke up this morning to a very pleasant surprise – Microsoft has delivered the long waited for Query...

Read more

Join two or more tables in Excel with Power Query

In this tutorial, we will look at how you can join tables in Excel based on one or more common columns by using Power Query and Merge Tables Wizard. Combining data from multiple tables is one of the most daunting tasks in Excel. If you decide to do it manually,...

Read more

Keep Only Numbers in Power QueryThe Excelguru Blog

My last blog post was interesting in that I got a few emails about it.  Both Imke Feldman and Bill Szysz sent me better methods, and a blog commenter asked for a slightly different version.  For this post, I’m going to adapt Imke’s technique to show how we can Keep...

Read more
Page 1 of 14 1 2 14

Welcome Back!

Login to your account below

Create New Account!

Fill the forms bellow to register

Retrieve your password

Please enter your username or email address to reset your password.

Add New Playlist