Export Data in Excel

[Mahyakiani]

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?Please help me.

[v-lgarikapat]

Hi @Mahyakiani ,

Thanks for reaching out to the Microsoft fabric community forum.

@jaineshp ,Thanks for your prompt response

@Mahyakiani ,

I wanted to follow up and confirm whether you’ve had the opportunity to review the information  provided by @jaineshp . If you have any questions or need further clarification, please don’t hesitate to reach out.

Best Regards,

Lakshmi

[Mahyakiani]

Thank you for reach out.

As I follow up the case, this is not possible to have excel export on filtered visuals.

But it would be great, if Microsoft consider it for next updates.

Thank you

[v-lgarikapat]

 Hi @Mahyakiani ,

This appears to be a current limitation in Power BI. I would recommend submitting this scenario as a feature request on the official Power BI Ideas forum. The Product Team actively monitors suggestions there, and items with strong community support are often considered for future enhancements.

You can submit your idea here

https://ideas.fabric.microsoft.com/

We appreciate your collaboration and support!

Best Regards,

Lakshmi.

[v-lgarikapat]

Hi @Mahyakiani ,

I just wanted to follow up with you to check if you had a chance to submit the scenario to the Ideas forum.

Best Regards,

Lakshmi

[Mahyakiani]

Dear @jaineshp 

Thank you for response, But I need a full detail of my filtere data list. With your proposed solution, it shows just a simple table of counted data like this photo.

I need a way to export full detail database which has been effected by 3 or more applied filter.

[jaineshp]

@Mahyakiani,

You will only be able to fetch the records that are present in the visual, not all the data.

Here, yes and no count are present in the visual, so you'll get only that data instead of all.

In short, whatever is present in your visual, you'll be able to extract only that in excel.

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

Best Regards,
Jainesh Poojara | Power BI Developer

[jaineshp]

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