Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 24

Thread: Article: M is for (Data) Monkey

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,317
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider

    Article: M is for (Data) Monkey



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Is the AdventureWorks2012 database at azuredb.powerqueryworkshop.com still up? Have the credentials changed?
    I bought the M is for (Data) Monkey book but I'm not able to connect with the credentials in Chapter 8.
    I am using the database (not windows) tab of the connection wizard as instructed, and I've made sure there are no typos.

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,317
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    It is, and no, the credentials are still as written in the book. Maybe there was a temporary outage, or your company prohibits connecting to our site, but it should be working. If anyone else has this issue, please shoot us a note from the contact form, as we get notified of that immediately and will look in to it.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #4

    Cool Fixed!

    Thanks for the reply. I got it to work! But there's a trick...

    I had tried to access the data using the credentials as written in the book. They still don't work.

    However, the "Info" tab of the "SQL Databases - Complete.xlsx" file in the "Ch08 Examples" folder informs both a different server connection and different database credentials! These work. So if anyone else has- the same trouble, just download the book files as informed at the end of chapter 0.

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,317
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hey there,

    So we tested the book credentials and they do still work. I'm wondering if maybe you tried to use a capital "o" in the password instead of a 0 (zero)? (Miguel has had a couple of calls with that exact issue.)

    Let me know,
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6
    Seeker carlosam14's Avatar
    Join Date
    Jun 2017
    Location
    Mexico
    Posts
    6
    Articles
    0
    Excel Version
    365

    Unhappy 1st Lesson, show Error and not change minus sign by parenthesis

    Hi Chapter 1 my query shows minus sign and 1 error after Close and Load...Why?
    Click image for larger version. 

Name:	Sin título.jpg 
Views:	48 
Size:	22.3 KB 
ID:	6936

  7. #7
    Seeker carlosam14's Avatar
    Join Date
    Jun 2017
    Location
    Mexico
    Posts
    6
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by carlosam14 View Post
    Hi Chapter 1 my query shows minus sign and 1 error after Close and Load...Why?
    Click image for larger version. 

Name:	Sin título.jpg 
Views:	48 
Size:	22.3 KB 
ID:	6936
    As can you see, for chapter 3, my pivot table show different values from book
    Click image for larger version. 

Name:	Pivot.jpg 
Views:	34 
Size:	22.1 KB 
ID:	6937

  8. #8
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,317
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi there,
    Quote Originally Posted by carlosam14 View Post
    Hi Chapter 1 my query shows minus sign and 1 error after Close and Load...Why?
    At this point in the book you should be seeing this error. It's actually related to the last row in the file that can't be converted into a date (a concept that we cover a bit later in the book.)

    With regards to the negative numbers, they are actually showing as text. If changing the type of that column results in errors, try to use the Change Type --> Using Locale and set it to English US as shown on page 24.

    Quote Originally Posted by carlosam14 View Post
    As can you see, for chapter 3, my pivot table show different values from book
    It looks like you missed the step on the bottom of page 27 to Remove Errors.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  9. #9
    Seeker carlosam14's Avatar
    Join Date
    Jun 2017
    Location
    Mexico
    Posts
    6
    Articles
    0
    Excel Version
    365

    Thanks Ken, this book its Great

    Quote Originally Posted by Ken Puls View Post
    Hi there,


    At this point in the book you should be seeing this error. It's actually related to the last row in the file that can't be converted into a date (a concept that we cover a bit later in the book.)

    With regards to the negative numbers, they are actually showing as text. If changing the type of that column results in errors, try to use the Change Type --> Using Locale and set it to English US as shown on page 24.


    It looks like you missed the step on the bottom of page 27 to Remove Errors.
    Thanks,

  10. #10
    Seeker carlosam14's Avatar
    Join Date
    Jun 2017
    Location
    Mexico
    Posts
    6
    Articles
    0
    Excel Version
    365
    I read all the book, very nice read and I really enjoy all figures, congrats to Miguel and you for making this book. I do it the work and make, start from 0 each example then compare with your complete's file, all Ok. at this point My request (for continue learn) to you is: Can share with me, some more examples, to continue learn.

    Thanks

Page 1 of 3 1 2 3 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •