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

Need Help

7 Replies

  • jaineshp's avatar
    jaineshp
    Memorable 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

  • Mahyakiani's avatar
    Mahyakiani
    New Member
    1 year ago

    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's avatar
      jaineshp
      Memorable Member
      1 year ago

      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

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    1 year ago

    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's avatar
      Mahyakiani
      New Member
      1 year ago

      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's avatar
        v-lgarikapat
        Community Support
        1 year ago

         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

        We appreciate your collaboration and support!

        Best Regards,
        Lakshmi.