cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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

‎02-10-2019 05:16 AM

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

Labels:
Message 1 of 2
2,305 Views
0
1 REPLY 1
v-cherch-msft
Microsoft
Microsoft

‎02-11-2019 12:08 AM

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.
Message 2 of 2
2,266 Views

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.

View All