Excel Data Refresh error to Analysis Services 2008

Published by AJ Alacan on

One of my developers was having an issue refreshing data using excel services in browser to Analysis Server 2008. It seems he added PowerPivot for excel that change some default connection string setting in excel. His connection string was generating “provider=MSOLAP.5;…” Which is not listed as a trusted provider in Excel Services.

Once i added MSOLAP.5 as a trusted provider, data refresh worked in browser!

Categories:

Related Posts

MS

Creating a Custom Connector for SolarWinds API Using Power Automate

In today’s digital landscape, automation is key to optimizing workflows and improving efficiency. If you’re managing IT operations or network monitoring with SolarWinds, integrating it with other tools and services can be incredibly valuable. Power Read more…

SharePoint Online Document Migration Tool: FREE

The SharePoint Migration Tool lets you migrate your files from SharePoint on-premises document libraries or your on-premises file shares and easily move them to either SharePoint or OneDrive in Office 365. It is available to Read more…

Unable to install Application Server Role, Web Server (IIS) Role SharePoint 2016

When installing on new win 2016 VM i got this error: Unable to install Application Server Role, Web Server (IIS) Role. Most solutions install features using Win Server ISO installation and Powershell. But you can enable Read more…