Forum Discussion
Data Format Error: More columns than expected
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
4 Replies
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
Can you post what solution to this you found?
