Adding Newer Data to Already Built Report

[darrennhg]

Hi Guys, 

So I've built a report as a tester for my manager that has a set of dates from 14th-20th of January. However now I've been given a list of the same report with different dates that I'm going to be receiving weekly. Will it be possible to link this folder where the reports are saved and have them refresh every time a new report is added?

[serpiva64]

Hi,

yes i think it is possible.

it depends on the format of the file you receive.

But without some sample data it's difficult for me to help you

[darrennhg]

	14/01/2022	15/01/2022	16/01/2022	17/01/2022	18/01/2022	19/01/2022	20/01/2022
3	Success	Success	Success	Success	Success	Success	Success
55	Success	Success	Success	Success	Success	Warning	Success
13	Success	Success	Success	Success	Success	Success	Success
7	Success	Success	Success	Success	Success	Success	-
4	Success	Success	Success	Success	Success	Success	-
54	Success	Success	Failed	Success	Success	Success	Success

Lets say this is the set of data for this week and then the next set of data from the 21st - 27th was a success with no fails or warnings.

[v-shex-msft · Accepted solution]

HI @darrennhg,

Did you mean your table stored multiple date fields that will be updated weekly?
If that is the case, I'd like to suggest you save these weekly files in the same folder to use the folder connector to get data.

Power Query Folder connector - Power Query | Microsoft Docs

Then you can add a custom column and nested 'unpivot columns' function to extract and convert these date fields to attribute(date) and value(status) to simply merge multiple files.

Unpivot columns - Power Query | Microsoft Docs
Regards,

Xiaoxin Sheng