Forum Discussion
kaarel
10 years agoResolver I
Excel Pivot Table OLAP live connectivity
Hi!
Is it possible to upload OLAP Pivot Table reports to Power BI and use REFRESH DATA?
Thanks,
Kaarel.
It is not possible to refresh the Excel Pivot table created on OLAP cubes/models. The Refresh is supported if the OLAP data is first fetched into Power Pivot and then created a Pivot Table on the Power Pivot Data Model .
The suggestion to enable that can be found on the link below
Please vote for it .
1 Reply
- mitsuResolver IV
It is not possible to refresh the Excel Pivot table created on OLAP cubes/models. The Refresh is supported if the OLAP data is first fetched into Power Pivot and then created a Pivot Table on the Power Pivot Data Model .
The suggestion to enable that can be found on the link below
Please vote for it .