Status:
Done
DataFormat.Error: We couldn't convert to Number. Details: Cross Ply - BUG?
Dear Power BI community, Im trying to update a power bi report with a new dataset. The data comes from an excel file that has 100% the same structure as the previous one except it has new data. ...
Hi Anonymous ,
Dataformat errors in Power Query are mostly data type errors and do not prevent you from loading data to Power BI, instead the cells will be loaded as blank.
To solve your problem,please do as the following thread：
How to Audit and Fix DataFormat Error in power Query - Ruki's Blog (rukiatu.com)
Best regards.
Community Support Team_ Caitlyn