+ Reply to Thread
Results 1 to 13 of 13

Pivot table from power query

  1. #1
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Pivot table from power query

    Hi guys
    I just hope you can help me.
    Normaly i do my pivot tables from a file or from a folder, but if i would like to do it, directly to the server, my excel doesn't "help" me on that.
    I mean, on my excel at home, excel 2016, i go to :
    Data - New query - From Database - From mysql database. Here i get to choose the server, database name, user and password.
    On my excel 365 at my office i don't have that option "from mysql database".

    Can you help on what to do to have it or "bypass" it?

    Tks in advance
    Best regards
    Pedro

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot table from power query

    Hi,

    Do you have the mySQL connector installed on your work computer?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Pivot table from power query

    I don't think so. Where can i find it to install it?

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot table from power query

    See the link in the article here- https://support.office.com/en-gb/art...ad=GB&fromAR=1

  5. #5
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Pivot table from power query

    Thank you very much.
    I'm at home now so i'll do it tomorrow and let you know.
    Thanks a lot

  6. #6
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Pivot table from power query

    Hello again
    Well...it didn't work and i didn't remember that i already had the connector installed. I did last year as an add in.
    It does not work cose it doesn't show me all the records and sometimes, doesn't allow me to import to change the way data will appear.
    Also, it does not add an option to import from mysql database from data-new query but an icon, like i'm showing you on the picture attached.
    Please let me know that you have another solution, cose this one doesn't work.
    Best regards
    Pedro
    Attached Images Attached Images

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot table from power query

    Hi,

    Which build of Excel 2016 is that?

  8. #8
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Pivot table from power query

    Hello
    Here it goes:

    Microsoft Office 365 Business
    Version 1703 (7967.2161)

    Tks for your interest

  9. #9
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot table from power query

    It looks like you are a version behind the one I have (mine is also ProPlus rather than Business), and presumably the one you have at home, which probably explains the lack of the mySql option. I do not know when that was added.

  10. #10
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Pivot table from power query

    Do you have ANY suggestions?

  11. #11
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot table from power query

    I'm afraid not unless you can persuade your IT people to update your version.

  12. #12
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,751

    Re: Pivot table from power query

    As far as I'm aware, you need specific license SKU for Office 365 to be able to bring in data from mySQL using PowerQuery.

    Office 365 Pro Plus, Enterprise 3 etc.
    Also Excel 2016 stand-alone will work.

    All other versions will have Access & MS SQL connection but will be missing some of others. If you don't see something like below in your "Get & Transform" menu, you'll probably need different licensing option.
    0.JPG

    Workaround is to bring in data through MS Query or other methods instead of PowerQuery.
    Last edited by CK76; 05-17-2017 at 09:58 AM. Reason: For clarity (specified PowerQuery in first sentence)
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  13. #13
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Pivot table from power query

    Thanks a lot guys for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  2. Power Query - add column with Table name
    By zico8 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-11-2017, 12:58 AM
  3. Replies: 0
    Last Post: 10-25-2016, 02:59 AM
  4. Power Query, Pivot, View and Map
    By olasa in forum Suggestions for Improvement
    Replies: 4
    Last Post: 07-20-2016, 08:14 AM
  5. Adding data to the end of a table with Power Query
    By afila in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2016, 08:29 AM
  6. Simple SQL Query in Power Pivot
    By zicitron in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-30-2014, 12:42 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1