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.

Thanks,

James