The issue may occur if Analysis Services lacks necessary permissions. Here, I suggest that you create new data connection in the Visual Studio project to be utilized for Excel data mining, and run the wizard for the Excel Data Mining
Plugin to configure Analysis Services permissions.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.