If you ever used Power BI, you know that you can create beautiful visuals, you can sort and manipulate all kinds of data from different data sources and even create predictive forecasting models. Great!
Everything about Power BI is looking so professional and I think is a great tool you can use in order to create complex data structures. One big thing is missing, though.
Here is what I am trying to say: If you are creating a pivot view or if you are sorting data, you can’t export that specific view to Excel. Summarized data is the option that should allow you to do just that, but is not doing what everyone is expecting.
When you export summarized data, after opening the excel file, you have the underlying data, in other words, all your hard work is gone and you should start over if you want to have the same view in the Excel file as in Power BI.
I was not aware of this limitation until today, when one of my customers wanted just that: to export the specific view he created using Power BI and use that file in a specific way.
I went online but I was unable to find this specific information. So, I opened a ticket to the Microsoft Power BI support team directly, and they confirmed that this feature is not available.
Is data export to Excel from Power BI going to be ever implemented?
I really think so!
In the “ideas” section of the Power BI forum I found someone that posted a request for implementing this feature back in Aug 2018 (source link).
At the time of writing this article there are 556 up-votes and 33 comments from users around the globe requesting the same thing.
I also got a verbal confirmation from the support team that they are working on this and is very likely to have this available by the end of 2020.
I wasn’t able to find a workaround and if you did so, please share it in the comment section bellow.
Thank you for reading this article! You can subscribe and get the latest articles (no spam).