Forum Discussion

Gopal_PV's avatar
Gopal_PV
Helper III
3 years ago

How to automate load multiple files from specific location & generate & export to specific location

Hi Folks,

 

Please please help me in this.

 

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Gopal_PV There's no API for doing that sort of thing. You can import all files in a folder using a Folder query but I'm not aware of anything native that will allow you to auto-generate a report. There is an API for exporting reports Power BI REST API.

    • Gopal_PV's avatar
      Gopal_PV
      Helper III
      Hi Greg_Deckler  Thank you for your quick reply

      How to automate this process. Is there any schedule Job. When I sechdule then That current year 2023 pass in source and load all the files.  I will create paginated report Then  multiple invoices placed in a specific location. 

      Thank you for your reply.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

        Gopal_PV Hmm, well, there may be some options for automated paginated report creation, I'll have to look into that. I did see paginated reports mentioned initially.