Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-18-2017, 06:51 AM   #1
machumpion
Newly Registered User
 
Join Date: May 2016
Location: canada
Posts: 93
Thanks: 49
Thanked 4 Times in 4 Posts
machumpion is on a distinguished road
Excel 2016- Loading Power Query into Power Pivot

For some reason I am unable to load data (connected to Oracle) I've modified with Power Query into Power Pivot.

From Power query, I created a connection to the data model only. From Power Pivot I then try to load it from "existing connections"

This is the message I get:
"The connection you’re trying to open was created with Power Query. To change this connection, use Power Query."

I then try to go to the Workbook Queries panel and "Load To" the data model. But the data still does not appear in Power Pivot.

Does anyone know how to do it?

machumpion is offline   Reply With Quote
Old 09-21-2017, 12:37 PM   #2
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,893
Thanks: 52
Thanked 680 Times in 628 Posts
ridders has a spectacular aura about ridders has a spectacular aura about
Re: Excel 2016- Loading Power Query into Power Pivot

Quote:
Originally Posted by machumpion View Post
For some reason I am unable to load data (connected to Oracle) I've modified with Power Query into Power Pivot.

From Power query, I created a connection to the data model only. From Power Pivot I then try to load it from "existing connections"

This is the message I get:
"The connection you’re trying to open was created with Power Query. To change this connection, use Power Query."

I then try to go to the Workbook Queries panel and "Load To" the data model. But the data still does not appear in Power Pivot.

Does anyone know how to do it?
I don't use pivot tables but I do use Power Query
Suggest you run Power Query on your imported data then save it as one or more worksheets depending on the data.
Then do the pivot table work on the worksheet created
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!
ridders is offline   Reply With Quote
Old 09-21-2017, 12:40 PM   #3
machumpion
Newly Registered User
 
Join Date: May 2016
Location: canada
Posts: 93
Thanks: 49
Thanked 4 Times in 4 Posts
machumpion is on a distinguished road
Re: Excel 2016- Loading Power Query into Power Pivot

it turns out when you initially load the Power Query you have to load it as connection only and not to the data model.

then in the workbook queries panel, you load it to the data model from there.

then it will appear in Power Pivot

machumpion is offline   Reply With Quote
Old 09-21-2017, 01:22 PM   #4
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,893
Thanks: 52
Thanked 680 Times in 628 Posts
ridders has a spectacular aura about ridders has a spectacular aura about
Re: Excel 2016- Loading Power Query into Power Pivot

Yes, that's effectively what I said!

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!
ridders is offline   Reply With Quote
The Following 2 Users Say Thank You to ridders For This Useful Post:
machumpion (09-21-2017), Rx_ (09-24-2017)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Power BI and Ms Access AnthonyGerrard General 0 04-19-2017 06:39 AM
Power Tip: Exclude data from a query by using a table HiTechCoach Queries 1 07-22-2010 03:57 PM
Designing a query to power report psycoperl Reports 5 04-16-2009 06:52 AM
query to power graphical representation Cappa101 Queries 0 11-08-2004 10:42 PM
power flow bakerboy_1111 Reports 1 12-09-2003 05:45 PM




All times are GMT -8. The time now is 05:27 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World