Tag Archives: power query

  • 3 New Power Query Patterns & Upcoming Power Query Workshop


    We’ve posted 3 new Patterns for you to look at in the Power Query Training site. These are:

    In case you’re late to the party, we have also released the new date for our upcoming Power Query Workshop. Check the details below.

    • 3

    • Workshop Summary

      • 2 Days of Content
      • 1 Q&A Session
      • 1 FREE eBook for each participant
      • 6 Assignments
      • Full HD Recordings in MP4 format

      Start Date: August 12, 2015 @ 10am UTC-0500h 

      Course Information
  • 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 implemented with nothing but M code in Power Query.

    Why? you might ask.

    Is not only a simple and quick solution, in the case that you don’t want to use Power Pivot, but it also has some major feature advantages that can make truly unique solutions that could take you more time to implement in Power Pivot or they might end up adding unnecessary complexity to an already complex Data Model.

    Let’s step into the solution and find out why this is a major step forward all Excel Users and even long-time Power Pivot users.

  • 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

  • Upcoming Excel & Power BI Youtube Videos

    If you haven’t check out our Excel, Power Pivot, Power Query and Power BI videos on Youtube then be sure to check out our channel:


    In the coming weeks I (Miguel) will be posting even more content, so be sure to check the channel and subscribe to get notified when the videos are up. For now, you can check out the new Channel Trailer that has a special participation of our Channel logo.

  • 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 started with Power Query and the M Language?

    Well, this post will try to tackle that question and give you a sense of how to start using Power Query and understand its language.

    I’ve divided this into 2 main sections that I truly believe should be first primary focus of our journey when we try to learn Power Query and the M language. These are:

    1. The Power Query & M mechanism or Workflow
    2. The actual M Language itself

    Let’s get started with the basics!

  • Combine Multiple excel, csv and txt files – New guest post on PowerPivotPro.com


    (Click on the image above to read the post)

    Have you ever wanted to Combine multiple:

    • Excel Files
      • Spreadsheets
      • Tables
      • Defined Names
    • CSV files
    • TXT files

    Find out the most optimal way to do so by reading my guest post on powerpivotpro.com

  • What is Power Query?

     Power Query unofficial logo(Power Query unofficial logo)

    A long overdue post!

    It’s a bit crazy that at this point I haven’t posted anything clearly defining what Power Query is and where it fits in the whole self-service BI experience with Power BI.

    So it’s time to actually sum up some points and post them here so we can clear that doubt about what really is Power Query and why you SHOULD care about it.

    What exactly is Power Query?

  • Combining Data From Multiple Excel Workbooks With Power Query–The Easy/Complete/Power BI Ready Way!

    In a series of multiple blog posts within the last few weeks, a lot of blog authors (Ken Puls, Chris Webb, Mike and many others) who I follow have raised the enthusiasm for combining multiple Excel Workbooks or even worksheets into a single table.

    All of our approaches have two things in common:

    • Calling a Function
    • Refer to a single type of object (most of the time it’s just a Worksheet)

    wich may not the best or most complete way to work with Power BI (on the cloud) since queries that refer to a function can not be refreshed on the cloud and also because you might want to combine sheets, tables and named ranges at the same time .

    Note that If you try refreshing a workbook that contains a Query with a function on Power BI, you’ll get an error similar to this:


    So, what if you could create a query that can combine anything and everything from multiple workbooks? Sonrisa READ THIS POST and you’ll see how

  • Getting API results from Azure Machine Learning into Power Query


    If you are into cool new technologies then this blog post is for you.

    A few weeks ago, Microsoft released a new service called Azure Machine Learning or simply #AML. It’s a cloud service that let’s you create experiments for data prediction and machine learning in general. (What Data Scientists do)

    You can read more about this service here (you can try it for FREE!!). What really has me hooked to this is the fact that it you can integrate r, so you can create your R code and even packages and use them on the cloud without doing anything special – an enfortless system bound to make things happen (or predict what would happen).

    This type of service is the one that saves hundreds of hours of development or tedious coding so I recommend you give it a try Sonrisa

    This blog post is based on this sample experiment

    We have the experiment ready – let’s use the API and grab some results with Power Query!