Excel import data from Teams folder

Question

I use some source data files to produce reports. Both the raw data and the report are Excel 2016. 

I in the report file I have pivot tables and connections to the data files.

If I move both files to Teams folders how do I create a new connection from the report file to the data file?

Answer 1

@Teresa

Each connection is a query (if problem well understood). And the path to the data source files is hard-coded into the queries, ie.:

Source = Excel.Workbook(File.Contents("D:\Documents\TEST.xlsx"), null, true)

*D:\Documents* is what you need to change if you want to move your data source file to ie. D:\Documents\Teams.

So:

1. Move your data source files to the desired folder
2. Edit each query and change the current path (via the Advanced Editor) with the new path

If you plan to move them again later let me know as it's possible to pass the information as a variable to the queries