Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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
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.
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |