Hi John,
According to your description, you get the error "Last successful refresh run: The cube has not been processed! " and there's no data in PowerPivot Dashboard. Right?
In this scenario, the error is not related to the installation. That's the issue on configuration. Please try to follow the steps below:
- SQL Server Reporting Server running under application pool SQL Server Reporting Service (with SharePointService credentials)
- Secure Store Service runnning under application pool Secure Store (with SharePointService credentials)
- Genereated a new Secure Store Key
- Created new Secure Store ID called PowerPivotUnattendedAccount
- Set target application administrators for PowerPivotUnattendedAccount to mydomain\SharePointConfig
- Set permissions for PowerPivotUnattendedAccount to mydomain\SharePointConfig
- Set credentials for PowerPivotUnattendedAccount to mydomain\PowerPivotRefresh, set the password for this domain account, set the credential owner to mydomain\administrator
- For the PowerPivot dashboard, went into PowerPivot service application settings and set 'PowerPivot Unattended Data Refresh Account' = PowerPivotUnattendedAccount
- For the account PowerPivotServiceApplication1_guid under security settings mydomain\SharePointService was only granted GeminiServiceAdmin.
Reference:
Creating cubes via PowerPivot
If you have any question, please feel free to ask.
Best Regards,