Forum Discussion

Mahyakiani's avatar
Mahyakiani
New Member
1 year ago

Export Data in Excel

Dear Community   I developed a dashboard via power BI, and there are some visuals on this page. As I applied some filter on it, I need to export filtered data behind it in excel, what should I do?...
Need Help
jaineshp's avatar
jaineshp
Icon for Memorable Member rankMemorable Member
1 year ago

Hey Mahyakiani,

Here's what you need to do:

Quick Export Steps:

  1. Click on the visual you want to export
  2. Hit the 3 dots (...) in the corner
  3. Choose "Export data"
  4. Pick "Summarized data" or "Underlying data"
  5. Click Export - done!

Pro tip: Your filters automatically carry over to the export, so whatever you're seeing filtered on screen is exactly what you'll get in the Excel file

If you need data from multiple charts, just repeat this for each one. Takes like couple of seconds per visual.

Fixed? ✓ Mark it • Share it • Help others!


Best Regards,
Jainesh Poojara | Power BI Developer