Problem : Power QUery will notload to Data Model

Background: A PowerQuery had been successfully combining data from a dozen large (101 cols x 100,000 row csv files. The table was extensively cut with ~80% rows filtered out , unwanted cvolumns remov...

BI & Data Analytics

Need Help

pdelreal365

Copper Contributor

Jan 20, 2020

Hello Wyn Hopkins,

I did some additional reading and it seems to be related with text case autocorrect options.

The actual amendments at the source data had several text case changes required. These changes were uploaded correctly into the Query table, but when moving into the Power Pivot data model it seem to "autocorrected" the text case.

I have stopped all the auto correct options at the PROOFING section at the EXCEL Options, but it does not seem to solve my problem.

Any advice?