Hey all,
I have a few report i extract daily and clean up in power query to give me a neat table with the data i need. Now as i have different markets i need to extract the same report multiple time for all markets. So the report structure does not change only the output data is from another market. Unfortunately there is no way to distinguish the different markets in the output report. Only when i rename them. So my question is:
Can i combine two query's made in power query so i can use the data in one pivot table?
I have noticed that i can combine tables in power query. But then when in say want to import that connection into a new file, the combined table is not shown in power query.
Any help would be highly appreciated as this keeps me up at night
Evil
I have a few report i extract daily and clean up in power query to give me a neat table with the data i need. Now as i have different markets i need to extract the same report multiple time for all markets. So the report structure does not change only the output data is from another market. Unfortunately there is no way to distinguish the different markets in the output report. Only when i rename them. So my question is:
Can i combine two query's made in power query so i can use the data in one pivot table?
I have noticed that i can combine tables in power query. But then when in say want to import that connection into a new file, the combined table is not shown in power query.
Any help would be highly appreciated as this keeps me up at night
Evil