Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: kbnosurvey, kbsolomonbp, kbmbspartner, kbgreatplainsbp, kbmbsmigrate, kbbug, kb

↑ Back to the top

Article Info
Article ID : 900944
Revision : 1
Created on : 3/25/2017
Published on : 1/9/2015
Exists online : False
Views : 95