Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
aguade
New Member

Dataflow Load error - There were more columns in the result than expected

Hello! Have a Dataflow with approximately 10M rows set up. When trying to create a report using Power BI Desktop (December 2018) the Apply Changes operation fails with error:

 

"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] There were more columns in thre result than expected...'"

 

I haven't done any operation on the Power Query, simply trying to load the data.

 

Any ideas ?

 

Thanks,

 

Augusto

1 REPLY 1
v-cherch-msft
Microsoft Employee
Microsoft Employee

Hi @aguade

 

Please check if the below post could help you.

https://community.powerbi.com/t5/Service/DataFlow-Refresh-Error-and-Fix-for-added-Fields-in-Dynamics...

 

Regardsm

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors