cancel
Showing results for 
Search instead for 
Did you mean: 
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
Microsoft

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.