You may receive a "Data Source Connection Error" error message when you try to locate Microsoft Business Portal queries by using Excel

Work anywhere from any device with Microsoft 365

Upgrade to Microsoft 365 to work anywhere with the latest features and updates.

Upgrade now


You use Microsoft Excel to try to locate the company folder that contains Microsoft Business Solution Business Portal queries or Microsoft Office Integration queries. In this case, you may receive the following error message:

Data Source Connection Error

The server for the data source returned a non-specific error when you try to execute your query. Check the format and content of your query and try again. If the problem persists, contact the server administrator.


If a query exists at the root of the folder structure in Organize Queries, you cannot search the folder structure by using Excel. By default, a query will exist in the root folder if a Key Performance Indicator (KPI) was created in Microsoft Business Portal. The default location for a query that was created for a KPI is at the root of the folder structure.


Create a new folder for the KPI queries, and then move the queries from the root level to the new folder. To do this, follow these steps:

  1. Click Site Settings, click Portal Elements, click Organize Queries, and then click Create Folder.

  2. Enter a folder name, such as "Queries for KPIs", and then click OK.

  3. Select the query at the root level, and then click Move to Folder.

  4. Click the new folder, and then click OK.

More Information

Steps to reproduce the behavior

  1. Install Microsoft Business Portal with the following two additional features:

    • Key Performance Indicators

    • Office 2003 English Web Parts and Components

  2. In Excel, follow these steps to connect to the Microsoft Business Solutions data source:

    1. Click Data, point to Import External Data, and then click Import Data.

    2. Click +Connect to New Data Source.odc, and then click Open.

    3. Click Microsoft Business Solutions, and then click Next.

    4. Enter the URL that you use to start Microsoft Business Portal, and then click Next.

    5. Double-click a company name, and then double-click QueryPages to verify that you can locate queries for the company.

  3. Create a KPI and an associated query. Save the query to the default location (/). See the following documentation in Microsoft Business Portal for steps to create both KPIs and queries:

    • KeyPerformanceIndicators.pdf

    • BusinessPortalUsersGuide.pdf

  4. Repeat step 2, and you will receive an error message.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.