Results 1 to 4 of 4

Thread: Power Query access on other machines

  1. #1
    Seeker kaia2001's Avatar
    Join Date
    Sep 2018
    Posts
    9
    Articles
    0
    Excel Version
    Office Standard 2013

    Power Query access on other machines



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

    Hi group!

    I have created a dashboard that uses an excel spreadsheet as its source data with a connection and loaded it to the data model. When others access and attempt to refresh the data they receive the error message below. Is there a way to link the data source and allow the end user to refresh the data source?

    Click image for larger version. 

Name:	Error msg.png 
Views:	9 
Size:	9.1 KB 
ID:	8454

  2. #2
    Neophyte Gavona's Avatar
    Join Date
    Sep 2018
    Posts
    4
    Articles
    0
    Excel Version
    10
    Do the users in question have Power Query?
    If not then what I did is constructed the data for my DashboardData workbook with powerquery and arranged a process to update it regularly (requires power query).
    End users had a workbook that used MS Query (built into all versions of excel) to pull relevant data from DashboardData (in my case using parameters including the username from the windows environment).

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,284
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Gavona is correct here. Since you're on Excel 2013, both author and consumer need to have Power Query installed. They don't necessarily have to use the same monthly package (as long as you're not doing anything that isn't supported in prior versions).

    Once you hit Excel 2016 and higher, this issue will go away as Power Query is built in to all SKUs of Office.
    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
    Seeker kaia2001's Avatar
    Join Date
    Sep 2018
    Posts
    9
    Articles
    0
    Excel Version
    Office Standard 2013
    Great thank you all!

Tags for this Thread

Posting Permissions

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