Data Monkey Basket – Supporting files for the book

Workbooks and Supporting Documents 

For ‘M is for Data Monkey’ (1st edition)

You probably got here from the link in our book ‘M is for Data Monkey’. This is the webpage where you can download all the workbooks that were used in the book, as well as other content, to help you master Power Query

You might also be interested in our other resources and products…

FREE eBook

Online Course

Power Query Recipes

Notes/Disclaimers/Feedback

This site is being monitored by both authors of the book, and we will read and take into consideration the comments published here.

The Content is provided “as is”, without warranty of any kind, either express or implied.

The Content contains valuable, proprietary content owned by the The Publisher and/or The Authors that is protected by state, federal, and international law, including, without limitation, copyright and trade secret laws. You may use the Content strictly for your own individual, personal use. The Content shall not be distributed, re-sold or used in a commercial manner.

Responses

Your email address will not be published. Required fields are marked *

  1. I am now in Chapter 4 of M is for (Data) Monkey, and so far the example files download has only contained one CSV file (the book called for more). All the files in the Ch04 Examples folder are Excel files – there are no CSV files as is needed to complete the Chapter 4 exercises. I guess I should skip to Chapter 5 where I will have the Excel files to aggregate? Is there another download available with the Chapter 4 CSV files?

    1. Hi Rodney, Thank you for reading ‘M is for Data Monkey’. I double-checked the example files for Chapter 4 and do see all of the various CSV files in there – they are organized in the subfolders based on the year. Hopefully if you go into these subfolders, you can find the various CSV files for each month in there. If for some reason you do not have these subfolders or the CSV files inside them, please email us through the Contact Us page (https://www.skillwave.training/contact-us/) and we’ll help get it sorted out.

  2. Hello:

    I want to create dynamic table headers. In his book, on page 83, he mentions the following example:
    “The file Ch09 Examples \ Dynamic Headers.xlsx contains a spreadsheet used for budgeting green fee rounds
    for a golf course … “.
    I just downloaded the file with the examples but I don´t find this one.

    Thank you.
    LQ

    1. Hi Luis, Thank you for reading ‘M is for Data Monkey’ though we’re sorry for the confusion over the example file for this chapter. The file you want to use is the one called Dynamic Tables.xlsx (unfortunately it was called Dynamic Headers.xlsx in the book). Hope this helps!

  3. Hi,
    Chapter 8, Importing from databases.
    When I try to connect to azuredb.powerqueryworkshop.com I receive the error “Unable to connect” Details: “AnalysisServices: Aconnection cannot be made. Ensure the server is running.”

    Could you please help me?
    Thanks

    1. Hi Ton, Thank you for reading “M is for Data Monkey” though I’m sorry that you cannot seem to connect to the sample database. If you can email us at [email protected] with the exact credentials you are trying to use, we’ll help you get it sorted out.

  4. Hi!
    I bought the book from amazon and, after downloading the example files, while working in chapter 5, I noticed the workbook “Consolidate Tables – Start” doesn’t have all the rows as shown in the book (In the book says it should show 124 rows 62 errors, but, when I work with this example, it only brings 62 rows with no errors (20 rows for Jan_2008, 16 rows for Feb_2008 and 26 rows for Mar_2008), could be an error because of the server changes mention by Miguel? Another thing I realized, there is no Chapter 13.

    Thanks!

    1. I realized something (and answer my self) in chapter 5 the workbook is not the problem, apparently, the power query I’m using is another version from the examples form the book (must be, the book is form 2015) and the Power query I’m using doesn’t create the “Gift_Certificate” table as an output, so, It does’t duplicate the rows as shown in the book (one step less for me). Anyway, the “mystery” with the chapter 13 continue.

      Thanks!

      1. Hi Carlos,
        Glad to hear you were able to figure out the question re: chapter 5. In terms of chapter 13, there are no example files provided for this chapter as the technique explained must connect to a live email address. We obviously cannot provide access to our Exchange account, so the steps outlined must be used with the reader’s own information. I hope this helps!

  5. I bought the paperback version of your book from Amazon.
    I’ve attempted to download files as instructed on page 9, but I get a 404 error message.
    Any idea what’s wrong?

    1. Hey Lee!
      We recently changed servers, so the issue could’ve been related to DNS propagation. Would you mind giving it a try again?

  6. Hi,

    In the exercise in Chapter 20, where you create a column for
    the ‘Previous Order Date’ using an [Index]-1 technique, pulling down and across
    the order date from the record above, each record is for a different ‘ID Number’.
    Surely here you are pulling in an order date for a different, say customer?

    How can this be modified to be customer specific, regardless
    of the order of the ID Numbers in preceding rows?

      1. Hey Miguel,
        Thanks for getting back to me. I signed up for the newsletter so I can check out your Data Wizard book, but as yet I’ve still to work out how I access/obtain this book?
        Thanks again for your help – much appreciate.
        James

        1. Hey James,

          Thanks for joining our newsletter! Once you sign up you should receive an email where you’d need to confirm/verify your subscription. Once that has been verified, you’ll almost immediately receive an email with the link to download a zip file that contains the eBook and the sample files. If you have any issues getting that email or downloading the files, please contact us via email at [email protected] where our support team will be able to help you get that sorted.

          Thanks again!!

  7. I am having a hard time following Chapter 16 Automating Refreshing – follow exact step by step, need to run the refresh code twice in order to have the “Transactions” sheet pivot table refreshing. unchecked the “Enable background refresh” on the “Transactions” connection eliminated the Pivot table not refreshing; however (when I remove records to simulate changes) the grouping was ungrouped and not allow to regroup. Anyone having this problem? I am running Excel 2013. most of my other solutions were resolved with “Refresh All” twice instead of having code automate the process.

  8. Has the azure database changed by anychance? I’ve not been able to connect, and have tried pinging both azuredb.powerqueryworkshop.com and ptypanama.database.windows.net. Both have time out

    1. Hey!

      Apologies for the delay on the reply. The credentials have not changed, but we did experience some downtime a couple months ago where we scaled and transferred our azure subscriptions. You should be able to connect to the database without any issues.

      1. Have the same problem currently. I’m using the credentials in the Kindle book version, however I get “the user was not authorized”. Triple checked they are correctly spelled. Any help, please?

        1. Hey Adrian,

          From past experiences, my best suggestion is to make sure that you’re selecting ‘Database’ Access and not ‘Windows’ Credentials as the server only handles database credentials.

          If you’re still getting issues then please contact us at [email protected]

          I can confirm that the server is up and running.

          Best!

          1. Hi Miguel,

            Definitely choosing Database not Windows connection. I will send an email to the provided email address.

            Thank you for the quick come back!

            Adrian

            1. Some other suggestions:

              1. Make sure that both the server address and the database names are defined when establishing the connection. The credentials only work for that specific database.
              2. If you’re copy/pasting the credentials, sometimes windows adds a white space a at the end so you might need to check that.
              3: if none of this works, send us the credentials that you’re using plus a screenshot of the error that you’re getting

              1. I got it. But I think the book has a typo or is not clear enough. Sent you an email.

  9. Just wanted to drop a note to say I’ve read your book cover to cover and completed all of the examples and I thought it was excellent.

    One question, it seems that since this book was written the functionality around referencing queries, using parameters and writing functions have been improved markedly by MS. I find MS documentation of this new functionality to be a it poor, any suggestions as to where I could look to learn to use this functionality?

    1. Hey Gary!

      Sorry for the late reply and thanks for the kind feedback. MS is constantly improving the whole Power Query experience every month, but at its core it remains the same. The native way to use parameters is pretty cool, but it’s way easier to implement a pseudo-parameter from an Excel Table and referencing to values inside that specific table than to implement the native parameters in Power Query.

      We have a new FREE eBook that goes over some of the new things of Power Query and you can get it here:
      https://www.skillwave.training/magic-tricks-data-wizards/

      Also, as part of our newsletter, we send a monthly roundup with all the new functionality that Power Query has and how you can take advantage of it. I encourage you to sign up to our newsletter so you can get your free copy of the eBook and also get more rewards and news from us in regards to Power Query.

    1. Luke, my guess is that you are using a non-subscription version of Excel 2016 (or you haven’t updated it). The fix was delivered to subscription users in Nov 2015 if I recall correctly (Excel 2016 was released Sep 2015.) I have no idea if/when we’ll ever see a rollup pack delivered to address this, as Microsoft is trying to get people onto their subscription model. Delivering the same features to those who are not subscribed would dilute the value for those who have. Try the Help –> Account –> Update and see if that works. Failing that, I don’t know what to say beyond try to move to a subscription version.