Power Query - Storing and Connections
I have a quick question involving Power Query.
I have created various queries that I have added to my data model in Excel. I have connected them all via Tabel_Key and a Date_File, and now have a pivot that pulls from these. What I would like to know is, is there a way to export a connection to the model without having to export all the queries?
The reason for this is I would like to create KPI reports from this, and would like to be able to just hold the pivot and connection in the report - so when I refresh it, the connection only needs refreshing to update from the query file, much like an OLAP cube.
Any help would be appreciated.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Reemet in forum Excel Programming / VBA / Macros
Last Post: 05-14-2015, 02:38 AM
By Glenn Kennedy in forum Excel Programming / VBA / Macros
Last Post: 12-21-2013, 06:16 AM
By giaco in forum Excel Programming / VBA / Macros
Last Post: 09-05-2013, 04:21 AM
By twointum in forum Excel General
Last Post: 06-27-2012, 01:25 PM
By mrIslic in forum Excel General
Last Post: 10-04-2011, 10:18 AM
By jamsta1972 in forum Excel General
Last Post: 01-04-2011, 06:20 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1