Forum Discussion

Kish1999's avatar
Kish1999
Icon for Helper II rankHelper II
2 years ago
Solved

Export Power BI Audit data to excel

Hello All, We have a requirement where our customers want to Automate their Audit process. The process is currently being done in excel where the auditors have a predefined set of questions and then...
Need Help
  • AnkitKukreja's avatar
    AnkitKukreja
    2 years ago

    Hi! Kish1999 

     

    Power Automate will help in this case as well, you can create a button to export your report or best approach would be what suparnababu8 suggested you should have it with power automate, once your auditor has completed their audit and you can trigger the flow maybe after comments are added or whatever last step they have is completed and that will send them the exported excel or maybe drop in a shared folder. 
    Or a button can also be added to export it manually - https://www.youtube.com/watch?v=BnTipbooeP0

     

     

     

     

Kish1999's avatar
Kish1999
Icon for Helper II rankHelper II
2 years ago

Hello AnkitKukreja , I can connect to the sources and get the data. The problem i have is how can i let the users enter their remarks and once they are done, export all the data in an excel in the format similar to the one in the attached image. Can you please provide some pointers related to this.