On a Win7 PC with Excel 2013 I'm missing Analysis Services KPIs in the Pivot Table Field List. I'm connecting to a 2014 SSAS cube. On a different PC logged in with the same user and the same cube the KPI node is visible so it can't be some permissions issue. I guess it's a settings or driver problem. But wher

Hi Thomas,

Based on your description, this issue only occurred on one PC, right? The driver as you guessed might be the issue here in this case. As you are using SSAS, please check if SQL driver is in place follow steps below:

Start -> Control Panel -> Administrative Tools -> ODBC Data Sources(32-bit)(if you are using Office 32-bit version, otherwise choose 64-bit) -> Drivers, under this tab, check if SQL driver is available there. If it's not there, please download and install the driver from here .

It's 6.01.7601.1751. I guess that's Windows 7 Standard...

Thanks

It's even worse, the menu entry where you can enable the calculated members to appear is missing... So no wonder that KPIs are not there as well. But what can be the reason for that?

It's even worse, the menu entry where you can enable the calculated members to appear is missing... So no wonder that KPIs are not there as well. But what can be the reason for that?

Hi Thomas:

Do you mind sharing me a screen grab with the error/symptoms you saw? So I can get a better understanding of this issue.