Forum Discussion

TePe's avatar
TePe
Helper IV
8 years ago

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...
Need Help
TePe's avatar
TePe
Helper IV
8 years ago

Hi,

 

currently the data is coming from a "private" Analysis Server where I don't have access to. So a colleague is filling up the Excel Pivot table with data and provides some "standard report" as spreadsheets in the workbook. However the data behind the Pivot Table is much richer than what you see in the workbook. Power BI seems only to access the workbook's data (meaning: what you see on the different spreadsheets), not the data behind the Pivot Table... When I look at what's presented as a data source when you import Excel content you only see the pages of the workbook. So my hope is very limited that we can already import Pivot Tables' raw data...

 

Thanks,

 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

TePe,

What options do you use to connect to the private SSAS in Excel? Have you used the option that I provide in my first reply to connect to the Excel?


Regards,
Lydia