- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Get data from files in the same folder
Hi there,
I hope to get some help on my problem for importing files that reside in the same folder with my master file.
In my folder, there are 6 forecast files and 1 master file
Folder A:
- Forecast file for banana
- Forecast file for apple
- Forecast file for orange
- Forecast file for pineapple
- Forecast file for lychee
- Forecast file for pear
- Master file for all fruit
I will get data > folder to combine all data from the 6 forecast files into my master file but I keep getting error when I try to refresh my query in master file because the master file is one of the files reside in this folder so I cannot run the run the query without closing the master file, and I can not trigger the refresh without open the master file. I am stuck here and hopefully someone could kindly advise me, thank you very much!!
Regards,
M

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi M,
It sound like some circular reference problem.
But in the main query where all files are combined (so not any of the helper queries), can you insert a step right after the source step to filter the file names and exclude the master file?
Hope that works.
Regards,
Wouter

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
8 | |
7 | |
6 |