web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need to automatically ...
Power Automate
Unanswered

Need to automatically download contents from power bi visual to update excel table.

(0) ShareShare
ReportReport
Posted on by

I'm having a hard time figuring out how to download the contents of a power BI Table Visual from an online report. I know you can export the dataset, but on this ocassion the report is created from a Tabular Model so connecting to the dataset would mean connecting to the entire model which I don't want. I just want to download the table as it is on the visual and update excel table rows. Is it possible to do such thing?

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,479 Super User 2025 Season 2 on at

    In Power BI hover over the visual. Click on the ellipsis ( ... ) then click on "Export data".  Choose "Excel with live connection".  Open the Excel file.  Go to the query properties. Steal Borrow the DAX query and use that in your flow.

  • RV-29011841-0 Profile Picture
    12 on at

    Really?  "Excel with live connection?"  Where is that?  I've been using Power BI for over 8 years and I've never seen that option.

  • lbendlin Profile Picture
    8,479 Super User 2025 Season 2 on at

    lbendlin_0-1692907402828.png

     

  • RV-29011841-0 Profile Picture
    12 on at

    Thank you.  I never noticed that that selection allowed "live connection"  Learn something new every day!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard