Forum Discussion
Getting the data behind an Excel Pivot Table into Power BI
Hi, I'd like to import data from an Excel Pivot Table. So to be clear: It's not a Power Pivot Model, it's not a table I have on a worksheet. It's created by giving Excel a data source (may be a c...
TePe Hello! Did you ever find a solution for this? I have same issue where my source is just a 'read only' excel report with 3 pivot tables. As an Excel user, i can double click to expand and retrieve the detailed data, but this source is not something we own or have access to (client provided). I need to automate the 'expand pivot table' step somehow in BI or PA to eliminate a user having to do that work before we can evaluate.
Unfortunately, not that I remember...