Data Format Error: More columns than expected

[Anonymous]

Good Afternoon, I loaded several entities from Dynamics 365 into Power BI Dataflows. I then loaded the dataflow to Power BI Desktop. Currently, two of the entities are throwing a data format error stating that there are more columns than expected when attempting to refresh. I refreshed the dataflow without any issue. I also tried deleting the entities and reloading them. The same error appeared. Any and all help is greatly appreciated as this is preventing the report from refreshing. Best, Austin

[v-juanli-msft]

Hi @Anonymous

Do you write some codes or implement some steps in Advanced editor in the dataflow?

Here are some similar threads you could refer to:

https://www.myonlinetraininghub.com/excel-forum/power-query/dataformat-error-there-were-more-columns

Force Power Query to Import as a Text File

If these above don't help you, please let me know what you implement in the dataflows.

“

Community Support Team _ Maggie Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

“

Best regards,

Maggie

[Anonymous]

Thank you for the response, but this was not what I was looking for. I figured out how to do it though!

[Mmahachi]

Can you post what solution to this you found?

[Anonymous]

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