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

     

     

     

     

suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
2 years ago

Hi Kish1999 

You can do this process by using Power Automate. Power Automate to schedule the export of the audit report to Excel at regular intervals.

Thanks!

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

    Hello suparnababu8 , Thank You for your reply!! 

    My requirement is to have the report exported once an Auditor completes their Audit and they press a button or something. Exporting at Regular intervals won't work here i think.

    • AnkitKukreja's avatar
      AnkitKukreja
      Icon for Super User rankSuper User
      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