Results 1 to 4 of 4

Thread: Other user are unable to refresh PQ without pulling source files in again

  1. #1
    Neophyte KJBeckski's Avatar
    Join Date
    Apr 2019
    Posts
    2
    Articles
    0
    Excel Version
    16

    Other user are unable to refresh PQ without pulling source files in again



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

    Hi-

    I have created several Power Queries that our team can benefit from running on their own. However when another team member opens the query to refresh after refreshing the master data files it gives an error message that reads: [DataSoure.Error]Could not find a part of the path 'X:\Promotions\Daily SFDC load\Promo ID Bids audit.xlsx.' (I have attached a screenshot). So basically if you didn't create the query then you cant run it.

    We all are running the same excel and all have access to the same files at our company. The only thing different is we are told to map our own drives here so I may be working on X for this file and someone else may be mapped to Z. I am not sure if that is what could be causing the issue or if there is something underlying that could be fixed so that when one created the query someone else can run it with out these issues.

    Any tips or information to help us resolve this issue would be appreciated!!!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	SnipImage (002).JPG 
Views:	12 
Size:	15.0 KB 
ID:	9012  

  2. #2
    Neophyte KJBeckski's Avatar
    Join Date
    Apr 2019
    Posts
    2
    Articles
    0
    Excel Version
    16
    Does anyone know any thoughts on how to solve the above issue?

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,245
    Articles
    0
    Excel Version
    Office 365 Subscription
    It will be the differences in drive mappings that is at issue. Have you tested with two people who've chosen the same drive letter?
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,585
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by KJBeckski View Post
    Does anyone know any thoughts on how to solve the above issue?
    Thoughts only:
    Use the UNC instead of mapped drive letter.
    Do an internet search on the likes of excel drive mappings unc
    Possibly useful:
    https://www.mrexcel.com/forum/excel-...e-letters.html
    http://www.excelfox.com/forum/showth...-Network-Drive

Posting Permissions

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