+ Reply to Thread
Results 1 to 3 of 3

How do you use power query on Mac when I can't link to anything but database and text?

  1. #1
    Forum Contributor
    Join Date
    05-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    O365 with latest Excel
    Posts
    107

    How do you use power query on Mac when I can't link to anything but database and text?

    I can't see any way to query data other than Database or text and html.

    I need to query various xls files...I can't figure out how to add them on Mac Excel O365. There doesn't even seem to be an option for querying other tables in the same workbook...what am I missing?

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,908

    Re: How do you use power query on Mac when I can't link to anything but database and text?

    That isn't Power Query, it's the old MS Query. On a Mac you can refresh existing power queries created on Windows, but that's all.
    Rory

  3. #3
    Forum Contributor
    Join Date
    05-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    O365 with latest Excel
    Posts
    107

    Re: How do you use power query on Mac when I can't link to anything but database and text?

    ok

    grrrrr

    thanks for the info tho!

+ 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. Dynamic CSV link in Power query
    By mikla90 in forum Excel General
    Replies: 9
    Last Post: 07-11-2019, 01:50 PM
  2. Power Query Sql Database Relationships
    By kersplash in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-28-2019, 07:42 AM
  3. Replies: 6
    Last Post: 03-18-2019, 02:02 PM
  4. Power query web link ?
    By common763 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-23-2018, 05:55 PM
  5. Connecting to Oracle Database & use SQL script in the Command Text NOT Power Query
    By elevate_yourself in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-06-2018, 05:01 PM
  6. Power Query MySQL Database error
    By brent_milne in forum Excel General
    Replies: 0
    Last Post: 08-21-2015, 11:21 AM
  7. Database Query-possible to link a spreadsheet to a database
    By COYF in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-04-2010, 09:37 AM

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