(It’s much longer than what you see in that little box.) Load Power Query directly to Power Pivotįinally, we’re going to pull this into Power Pivot. Note: Make sure you start at “Provider=” and highlight all the way to the end. But the key for us is the connection string shown (#2 in the image above). Notice that this query is actually an OLE DB Query that is simply “SELECT * FROM ” That seems easy to work with. Now you’ll be looking at something like this: In there, you’ll see the name of your new connection: We need to get the connection string that Excel uses to connect to the Power Query. Choose “Only Create Connection” –> LoadĪnd I’ve now got a basic connection to my sales table without landing it in a worksheet:.Next, we go to the Home tab –> Close and Load –> Close and Load To….I do whatever cleanup is needed and name the query Sales.I browsed to the file I needed, and imported it into Power Query.Go to Power Query –> From File –> From Text.Let’s look at the required steps Step 1: Create Your Connectionįirst, I’m going to load in the content of a text file. Interestingly, you can still load Power Query directly to Power Pivot in Excel 2010, it just takes a bit of a careful workaround. But Excel 2010 doesn’t appear to have this feature. One of the cool features in Excel 2013’s Power Query is being able to load to the Data Model (PowerPivot) directly.
0 Comments
Leave a Reply. |