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...
Does power bi have an option to get data from the underlying tabular data from a pivot table in Excel? Given you can usually just double click the totals rows in the Excel pivot table to show the tabular data, it seems like this shouldn't be an impossible update in one of the monthly releases. Does anyone know if this is currently possible because just like TePe there are instances where you don't have access to the direct data source but you do have access to just a pivot table.