web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / ADLS2 - Warning: Numbe...
Customer experience | Sales, Customer Insights,...
Unanswered

ADLS2 - Warning: Number of columns in source data file does not match the number of attributes

(0) ShareShare
ReportReport
Posted on by Johannes Wagner 45

Hi Community,

I am facing the following issue: I have a CDM folder in ADLS2 with a "clean" test data table (generated by Power BI dataflow, so the format should be ok).

I can import this datasource using PowerQuery and the ADLS2 connector (CDM) with no problems.

When I import the same CDM folder  connecting directly to the ADLS2 (import method) "Azure data lake storage" it always completes with the following Warning:

"Number of columns in source data file does not match the number of attributes: [n] defined in the source data schema for the entity '[tablename]'.

Any thoughts on this are appreciated.

Thanks!

I have the same question (0)
  • Bill Ryan Profile Picture
    Bill Ryan 8 on at

    My first guess is that it's schema drift if it's CSV but if it's parquet than that's unlikely.  If you look at the Column Count in the Dataflow, can you confirm it's the same number of attributes that are being defined?  It's possilbe that the manifest.json/model.json file didn't get updated at some point, so you can always downloand and check it and modify if you see something else is in there.

  • Johannes Wagner Profile Picture
    Johannes Wagner 45 on at

    Thanks Bill!

    I have checked the schema in all places (ADLS/model.json, CI, PowerQuery) and it is identical everywhere. It is a very simple test table so this can be easily verified.

    And both ADLS and Powerquery read from exactly the same source.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 197 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 70

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans