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

What Copilot “Cowork” Means for Business Users

Zoltan Orban

|

March 26, 2026
Microsoft recently introduced Copilot Cowork, and I wanted to take a closer look at what it represents in practical terms, especially for business users working across Microsoft 365 and related…

Why CRM Data Quality Matters More Than Data Volume

Marisa Mini

|

March 24, 2026
A database of 100,000 messy, outdated records is far less valuable than 5,000 that are clean and accurate. Companies often obsess over data volume. But when more data is prioritized over…

From Reactive to Predictive: AI in Business Central Distribution

Zoltan Orban

|

March 19, 2026
Most distribution teams don’t lack reporting. If anything, they often have too much of it. Dashboards, planning worksheets, inventory reports, and KPIs are readily available inside Dynamics 365 Business Central. Yet…

AI Agents in Business Central: How the Payables Agent Works

Jennifer Ryan

|

March 17, 2026
If you're curious how AI agents in Microsoft Dynamics 365 Business Central actually work, we're hosting a live walkthrough of the Payables Agent on March 26. See live how the agent…

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…