Create an OLAP Data Source

• Jan 05, 2026
• 2 minutes to read

Prerequisites

1. Register a data connection string provider.

   The Web Dashboard control does not expose connection strings from the configuration file (appsettings.json or Web.config) when used in Designer mode. You need to use a data connection string provider to avoid data leaks and pass connection parameters safely. You can use a predefined data connection string provider or implement a custom provider.

   For additional information, refer to the following help topics:

   • Data Connection Security (ASP.NET Core)
   • Data Connection Security (ASP.NET MVC)
   • Data Connection Security (ASP.NET Web Forms)

2. The ASP.NET Core Dashboard control supports the following data providers in OLAP mode:

• XML for Analysis (XMLA) with MSMDPUMP;
• ADOMD.NET.

Use the OlapDataProvider property to specify the data provider.

To use the ADOMD.NET data provider, install the Microsoft.AnalysisServices.AdomdClient NuGet package.

Select a Data Connection

The Choose a data connection page appears if you select OLAP on the start page. Select an existing connection from the list.

For information on how to register data connections in your application, refer to the following help topics:

• ASP.NET Core
• ASP.NET MVC
• ASP.NET Web Forms

Click Finish to create an OLAP data source.

API

The OLAP wizard page is identified by the following API:

Page Name	Page ID	Class
Choose Connection (OLAP)	OlapDataSourceWizardPageId.ChooseConnectionPage	DashboardChooseOlapConnectionStringPage