Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Our organization has a few reports that need a static lookback at results for each of our fiscal periods. An example is our accounts recevables aging list. It needs to be pulled each month and then combined to show our monthly aging schedules.
I was wondering if there is a way to reference a power query group (an organized group of queries) so that we don't have to manually type each query name in Table.Combine() when we upload a new month? If not, should we submit a request to get this feature added?
I've researched this for about an hour and haven't come up with anything yet! Hopefully you guys can help out?
Solved! Go to Solution.
Hi @Anonymous,
Can please share some dummy data with a similar data structure? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
BTW, if your files are stored in a folder, you can try to use a folder connector to get the list of first and direct use combine function with that file lists. (Table.Combine function use list as the parameter, you can try to use 'source name' and 'column name' to extract the file list)
let
Source = Table.Combine(QueryName[ColumnName])
in
Source
M query operator
Regards,
Xiaoxin Sheng
Hi, have you figured out a way to do this?
Hi @Anonymous,
Can please share some dummy data with a similar data structure? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
BTW, if your files are stored in a folder, you can try to use a folder connector to get the list of first and direct use combine function with that file lists. (Table.Combine function use list as the parameter, you can try to use 'source name' and 'column name' to extract the file list)
let
Source = Table.Combine(QueryName[ColumnName])
in
Source
M query operator
Regards,
Xiaoxin Sheng
@Anonymous
How are you loadng all these tables? Are they from files or a folder?
Have you tried the Folder connector which allows you to easily combine files in the way you are describing?
regards
Phil
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |