Forum Discussion

vishal10306's avatar
vishal10306
Frequent Visitor
3 years ago
Solved

How to filter Power BI dataset in Excel before creating pivot tables out of it

Hi All,   I have a Power BI dataset published on Service with multiple country data. I am using this dataset in Excel to create some pivote tables. But I want to create a saperate Excel for each co...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi vishal10306 ,

     

    We can see the following sentence in the official documentation Start in Power BI with Analyze in Excel - Power BI | Microsoft Learn：

     

    This means that Analyze in excel is to import all the data into Excel, so the filter will not be applied in Excel.

     

    As a workaroud，you could use export data feature.

    1. First select the data of the country you need in the filter pane, then click on the visual options>select Export data.

     


    2. There are three options to choose from, you can choose according to your needs.

     

     

    Based on your situation, we recommend you to export underlying data, if this option is grayed out, you can turn on this function in Power BI Desktop > options and settings and republish it.

     

    Then you will get a file like this：

     

     

    If you want to see some restrictions related to export data. You can refer to this document.

    Export data from a Power BI visualization - Power BI | Microsoft Learn

     

     

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.