Power Queries - Store Common tables at centralize location

[sanket_sk]

Hi There!!

I hope everybody is safe and sound in this pandemic situation !!!

I am Sanket, recently stared working on Power Query, I have very low rather no knowledge on power queries.

Currently I am using office 365 Pro Plus version.

Day in / out we are working on excel extracting number of reports, these reports are new on daily basis but few tables are common.

For example, List of service providers, Branch Region matrix table, product information table, Sparparts table and so on, till now I was creating daily report by applying Vlookup with these common tables.

With power Query I have started extracting these reports by Merge query. Currently I am importing Raw content of report and common tables every time to extract report.

I tried to make connection only data for common tables but it is working only in same workbook.

My question – Is there any way by which we can store / upload all common tables at central place in power query back end and use these tables whenever required in different workbooks?

Thanks & Regards,
Sanket

 

[alansidman]

Reverse your procedure and have your Common Tables in a file. Use this file as your starting point. Use Get Data to bring your daily reports into PQ with the common table file. In this manner, you are bringing the new data to the Common Table file instead of bringing the common table files to the new data. See if this works for you.