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


Symptoms


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.

Cause


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.

Resolution


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.