Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

export data from power bi visuals to excel automatically

How can I export data from power bi visuals to excel automatically?
Need Help
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi Anonymous ,

    You can create a Power Automate flow to export visual data automatically by clicking the flow button.

     

    Please refer this viedo which introduces it step by step:

    Power BI export to excel and csv with Power Automate 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago
v-yingjl wrote:

You can create a Power Automate flow to export visual data automatically by clicking the flow button.

 

It's not really an automatic export if it requires pressing a button, is it?

 

How would one export the data from a table without the button press (e.g. every evening at 8pm)?

uzeq's avatar
uzeq
Advocate I
2 years ago

Check out my responses in this thread. I do my data pull on a schedule via Power Automate, no manual intervention. It's been some time but that's what I have been doing and the process has been stable.

Here:
https://community.fabric.microsoft.com/t5/Power-Query/export-data-from-power-bi-visuals-to-excel-automatically/m-p/2900878/highlight/true#M91452
and here:
https://community.fabric.microsoft.com/t5/Power-Query/export-data-from-power-bi-visuals-to-excel-automatically/m-p/3205555/highlight/true#M103097