Edit

Share via

Connect the Sales Research Agent to a different data source or upload data

The Sales Research Agent is connected to your Dynamics 365 Sales environment by default. However, you can connect to other Dataverse environments or upload data files (CSV, Excel, PDF) as additional data sources with sales and business data. You can also choose to remove existing connection entirely and just use the uploaded files as basis for your research. This allows you to create comprehensive research blueprints with the Dynamics 365 data, uploaded data, or both combined.

Considerations

  • If you have access to multiple environments, choose the environment that has the data you want to analyze.

  • Based on the question you ask, the agent looks through the data source for the most relevant data to answer the question. The agent depends on the metadata available (for example, table, column headers, and descriptions) to help identify the most relevant data.

  • Make sure that custom tables and fields added to Dynamics 365 Sales have proper descriptions. The agent uses these descriptions to understand the data and provide better insights. If these descriptions are missing, you might need to add natural language data instructions in a business function. Learn more in Provide context to enhance the Sales Research Agent.

  • The blueprint generated depends on the data found. If no data is found, then the Sales Research Agent shows an error and might ask if you can rephrase the question.

  • If you use the AI cursor to ask follow-up questions, the agent considers the same data source to answer it unless you specify a different data source.

Connect to a data source

Select Add data in the Ask any business question prompt box to connect to a different data source or upload files.

Screenshot of the Add data option in the Sales Research Agent.

For Microsoft Fabric Lakehouse connection, read the article Connect Sales Research Agent to Microsoft Fabric Lakehouse for detailed instructions and considerations.

Supported data files

You can upload a PDF (.pdf), CSV (.csv), or Excel (.xls) file. The following limitations apply to file uploads:

  • The maximum supported file size is 10 MB.
  • The maximum number of uploaded files is 5, and the maximum total size for all files is 30 MB.
  • Encrypted, password-protected, or copyright-managed files aren't supported.
  • CSV:
    • Data within the file needs to be separated by commas.
  • Excel:
    • Column header in the first row only.
    • No more than 10 tables and a maximum of 50 columns for each table.
    • Can't contain merged cells.
    • Elements such as images, charts, and macros can't be processed.
  • PDF:
    • 150 maximum supported number of pages per file.
    • Must contain selectable text. You can test it by trying to highlight text within the PDF. If you can't select or highlight the text, then it can't be processed.
    • Use original digital documents or PDFs that are converted directly from word processors or other digital sources. A scanned PDF doesn't work.
    • If the PDF contains tables, make sure the borders are clearly outlined. Avoid using any contrasting colors to differentiate between rows and columns.
  • Last updated on