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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Data Import Error (schema mismatch)

(0) ShareShare
ReportReport
Posted on by 45

Hi Community,

We are loading several tables form a Azure data lake Gen2 (CDM folders). The system is in productive use since a few months where we built several (complex) measures and segments.

Recently we recently realized import errors on several tables where the error message says:

Error: Number of columns in source data file does not match the number of attributes: {AttributeCount} defined in the source data schema for the entity '[table name]'

(The data still seems to load correctly)

When I try to review/edit the data source, CI tells me I have to first remove the table from all relationships/measures/segements etc. This would be a massive task and cause a downtime for several days (basically we would have to "rebuild" almost everything).

How can I find out which columns are causing the issue? Is there any other way to analyze this and "reset" the data schema within CI and fix this?

I have the same question (0)
  • Mukesh Pohuja Profile Picture
    on at

    1. Were the files on the ADLS still in the middle of a refresh, before the Data source refresh started? 

     2. Any chance there are new lines in the data, thats throwing off the col counts.

    3. Under entities, Is there a corrupt entity that you can check for data skew?

  • Johannes Wagner Profile Picture
    45 on at

    Hi Mukesh, thanks for your suggestions

    1) No. All ADLS refreshes are complete when CI refreh startes

    2) Yes. There are issues with line breaks that cause "corrupt" records (this is yet another problem)

    3) Yes. However, this occurs in different entities not related to the schema error

  • Mukesh Pohuja Profile Picture
    on at

    can you reach out to CIHelp@microsoft.com for investigation?

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 43 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans