Forum Discussion

Siim Lüüs's avatar
Siim Lüüs
Copper Contributor
Dec 19, 2017

Power query - two-way data moving

Hello,

Is there any possibility to transfer data with power query two-way?

1. I have one excel file for "orders".

2. From "orders" excel i transfer order rows with category "P" using power query to "purchase" excel and purchasing departments adds purchase info.

3. From "orders" excel i transfer order rows with category "M" using power query to "manufacturing" excel and manufacturing department adds manufacturing info.

4. From "purchase" and "manufacturing" orders i transfer and merge data using power query to "logistic" excel where logistic department adds logistic info.

5. Finally, i want to transfer logistic data from "logistic" excel back to "purchase" and "manufacturing" excel. I tried to use index and match formula but it makes it slow. Can this be done with power query?

Thanks, 
Siim

BI & Data Analytics
Power Query

1 Reply

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Dec 20, 2017
    Hi Siim, the answer is not really, or rather maybe but you probably shouldn't. This is the sort of thing that Access or another database type programme is designed for - allowing multiple users to write against multiple records and keep control of the whole process.

    The ability for multiple users to edit the same Excel document saved to OneDrive may be an option but I'd really investigate the database option.