See Microsoft 365 Copilot in action across Outlook, Teams, Excel + more.

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.

Share On: 

Other articles

Free vs Paid: How Microsoft 365 Copilot Unlocks Real Productivity ROI

TJ Sedarski

|

November 13, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more. Copilot Free Chat is a good place to start in…

What the 2026 Business Central Updates Mean for Small and Midsized Organizations

Lupe Haro

|

November 12, 2025
Microsoft is doubling down on what matters most to today’s small and midsized organizations: automation, intelligence, and agility.The upcoming Dynamics 365 Business Central 2026 Release Wave 1 focuses on AI-powered…

Microsoft 365 Copilot Is Hot! Highlights from Community Summit 2025

TJ Sedarski

|

November 11, 2025
This article is part of our “Work Smarter with Copilot” series—spotlighting the latest Microsoft 365 Copilot updates announced at Community Summit 2025.One message rang loud and clear at this year’s…

How Microsoft 365 Copilot in Outlook Helps You Manage Email Smarter (and Tame Your Inbox)

Joel Trinidad

|

November 7, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.The Email Overload Holding Teams BackFor most of…

Copilot for Power BI: Your Personal Data Assistant

Joel Trinidad

|

October 30, 2025
Microsoft has been steadily adding AI features to their broad range of business products, and Power BI is no exception. Copilot can be utilized to take full advantage of your…

How to Migrate Fixed Assets from Dynamics GP to Business Central Smoothly

George Rios

|

October 28, 2025
PlanningWhen working on a migration of Dynamics GP fixed assets to Business Central, you will want to identify which fields you want to transfer from one system to another. It…