web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    RE: ADLS2 - Warning: Number of columns in source data file does not match the number of attributes

    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
    RE: ADLS2 - Warning: Number of columns in source data file does not match the number of attributes

    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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 228

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 156 Super User 2025 Season 2

#3
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 149

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans