Forum Discussion

kb177's avatar
kb177
Icon for Helper II rankHelper II
3 years ago

Add data automatically to Report

Hello,

 

I'm trying to automate data on existing report, we get a file with same columns every week or month, I'm looking to just add that file to that folder where previous files are stored and data in our report should get refreshed

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hi kb177 , 

     

    Have you tried to use powerautomate to move the file into the relevant folder. You can then use powequery to import the folder of data as required.

     

    Hope this helps.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

    • kb177's avatar
      kb177
      Icon for Helper II rankHelper II
      3 years ago

      I dont have power automate subscription