Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : KRm1CjQjSJCA2xepz17Z2E
Customer experience | Sales, Customer Insights,...
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 2 Jun 2022 11:56:33 by 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!

  • Johannes Wagner Profile Picture
    45 on 02 Jun 2022 at 13:58:26
    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.

  • Bill Ryan Profile Picture
    8 on 02 Jun 2022 at 13:55:13
    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.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading complete