If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is now here. You can now export the data that is behind a visual and this will close a huge gap for Power BI when compared to many of it’s competitors. For myself this is beyond huge as all I have been hearing from clients for the past 5 months is, “When are exports going to be available?”. The answer is finally here and it is very simplistic to use.
For any visual all you have to do is select the menu in the top right and choose export data.
It is that easy and you will get a download the data in excel for that visual. One note is that it does not drill down into the data. The export will have at the same level the visualization is at. For example in the above visual the following are the results.
However if you choose a visual with more detailed data such as a table the below would be the visual and result pair.
Or in a column chart
Happy exporting everyone!