Download data from Power BI table with the help of power automate flow

(1) Share

Report

Posted on by CU22051140-0

Hi Folks,

I’m trying to download data from a Power BI table with dynamic plant selection. When the process is triggered via Power Automate, I want the filtered data to be exported and downloaded in .xlsx format.

Is there a way to achieve this? Any suggestions or guidance would be appreciated.
Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU22051140-0

This can be achieved, but Power Automate does not directly export the currently filtered Power BI table visual to .xlsx in the same way as the manual Export data option.

In the flow, use Run a query against a dataset or the Power BI REST API Execute Queries action to run a DAX query with the Plant filter applied.

The result can then be written into an Excel table/template stored in OneDrive or SharePoint, and the generated .xlsx file can be emailed or saved for download.

Check the blog for more information:

http://matthewdevaney.com/power-automate-run-a-query-against-a-power-bi-dataset/

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
SpongYe Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my blog [@S pongYe] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Suggested answer

Vish WR 3,748 on at

Like
a
(0)

Report
Copy link

Link copied!

@CU22051140-0

Hi, yes this is doable. Power Automate can't directly export a filtered visual like the manual Export Data button does, but you can work around it.

Use the Run a query against a dataset action in Power Automate to run a DAX query with your plant filter applied. That gives you the filtered data as JSON, which you can then write into an Excel file stored in SharePoint or OneDrive and email it out or save it for download.

Refer to the suggested blog

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(0)

Report
Copy link

Link copied!

@CU22051140-0

Wanted to check if you are able to resolve your problem? Let me know if you need any clarification

When replying, please don't forget to mention my userid so that it will be notified

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No