Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Adding Newer Data to Already Built Report

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?

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI Anonymous,

    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

3 Replies

  • serpiva64's avatar
    serpiva64
    Icon for Solution Sage rankSolution Sage
    4 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago
       14/01/202215/01/202216/01/202217/01/202218/01/202219/01/202220/01/2022
      3SuccessSuccessSuccessSuccessSuccessSuccessSuccess
      55SuccessSuccessSuccessSuccessSuccessWarningSuccess
      13SuccessSuccessSuccessSuccessSuccessSuccessSuccess
      7SuccessSuccessSuccessSuccessSuccessSuccess-
      4SuccessSuccessSuccessSuccessSuccessSuccess-
      54SuccessSuccessFailedSuccessSuccessSuccessSuccess

       

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        HI Anonymous,

        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