I'm trying to set up a power pivot to dump order data into a pivot table. When I go into Manage in the Power Pivot I can not find the existing connections set up. When Normally using excel and pulling in data I just go to data>from other sources>MS query and I can see the database connections I'm trying to get to so that I can bring in the info I need. What do I need to do to have those same connections come up in Power Pivot? Can someone please walk me through the set up process for how I need to do this.
Also, I would need to bring in another excel file, items I only want orders to show if they have those items, into the power pivot. How would I do that? I assume once it's in there just setting a link with it and the table that has the data coming into the power pivot to get it to only show those orders.
Also, I would need to bring in another excel file, items I only want orders to show if they have those items, into the power pivot. How would I do that? I assume once it's in there just setting a link with it and the table that has the data coming into the power pivot to get it to only show those orders.