+ Reply to Thread
Results 1 to 4 of 4

Multiple Power Queries using same Source File

  1. #1
    Registered User
    Join Date
    02-08-2023
    Location
    Anytown, USA
    MS-Off Ver
    2010
    Posts
    13

    Multiple Power Queries using same Source File

    User1 has ExcelFile1 open. It uses PowerQuery to access SourceFile1.
    User2 has ExcelFile2 open. It uses PowerQuery to also access SourceFile1.
    SourceFile1 is a csv file, not saved as read-only.

    What happens when both users refresh their queries simultaneously and try to access the same source file? Will there be a conflict/error, and if so, is there any solution to avoid this?

    Thanks.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Multiple Power Queries using same Source File

    Power Query read the csv file not write back so there shouldn't be any conflict

  3. #3
    Registered User
    Join Date
    02-08-2023
    Location
    Anytown, USA
    MS-Off Ver
    2010
    Posts
    13

    Re: Multiple Power Queries using same Source File

    That's good news. Thanks for your reply.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Multiple Power Queries using same Source File

    You are welcome

    Have you ever met a case where two users did it exactly at the same time?

+ 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. VBA for removing Power Queries and saving file as a new file
    By daithy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2023, 10:45 AM
  2. Multiple Queries as a Source for a New Query
    By AllisterB in forum Excel General
    Replies: 0
    Last Post: 04-27-2021, 03:19 PM
  3. [SOLVED] Multiple Queries as Source in a Power Query
    By AllisterB in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-27-2021, 06:07 AM
  4. Replies: 0
    Last Post: 05-07-2020, 01:53 PM
  5. Replies: 1
    Last Post: 03-09-2019, 11:51 PM
  6. Replies: 1
    Last Post: 03-03-2019, 05:20 PM
  7. Help with multiple URLs and auto Power Queries
    By joffy1979 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2015, 04:28 AM

Tags for this Thread

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