Microsoft Copilot $21 now $18/user/month + 1 month free

July 24, 2023

Query cannot be previewed due to the following problem – there are no columns defined

We recently came across a case where Integration Manager was not able to read any records despite the fact that the source file referenced in the integration was correct and contained valid data when the file was opened in Notepad.

When we tried to preview the file contents, we received the following message:

For whatever reason Integration Manager does not like multiple periods in the file name, which originally was ‘Invoices_MM.DD.YYYY.csv’. After removing the periods that were used as separators in the file name, the file was correctly read by Integration Manager as we had initially expected. If you are still encountering a similar problem, please reach out to us at Support@BondConsultingServices.com for an appropriate solution recommendation. Trust in the expertise of BCS to optimize your ERP investment.

Other articles

Migrating 1.3 Million CRM Records in Dynamics 365: Why We Used a Custom Console App

Marisa Mini

|

March 5, 2026
A government client needed to restructure 1.3 million contact records in Microsoft Dynamics 365 CRM. At that scale, traditional UI tools and flows can throttle, fail silently, or leave a…

AI Agents in Manufacturing ERP: D365 Business Central Guide

Seetharaman Andiappan Rajaram

|

March 4, 2026
AI agents are now live inside Microsoft Dynamics 365 Business Central. For manufacturers evaluating AI in ERP systems, the practical question isn’t what an agent is it’s how AI agents…

How to Use D365 Business Central Analysis Mode

Carlos Lozano

|

March 3, 2026
Transforming Data into Decisions for Modern Businesses Organizations using Microsoft Dynamics 365 Business Central generate significant volumes of financial and operational data. However, collecting data is only the first step. The…

BCS Partners with RUX Software to Deliver Equipment Rental and Field Service on Business Central

Jackie Gant

|

February 26, 2026
Bond Consulting Services (BCS) has partnered with RUX Software to deliver equipment rental and asset management capabilities for small and mid-sized businesses running on or moving to Microsoft Dynamics 365…

What AI Agents in Dynamics 365 Actually Do (A Plain-English Guide)

Jennifer Ryan

|

February 19, 2026
From Assistance to ActionIf you've been using Microsoft 365 Copilot, you've probably noticed something shift. Email gets drafted faster. Meeting notes appear without you scrambling. Spreadsheet analysis that used to…

D365 Business Central: Realistic AI Agent Scenarios for Operations Teams

Zoltan Orban

|

February 18, 2026
A Practical Look at Where AI Actually Helps in BC TodayThere’s a lot of talk about AI and ERP becoming fully automated. In reality, most teams aren’t trying to replace…