Forum Discussion

Copper Contributor

Feb 22, 2019

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

Wyn Hopkins

MVP

Feb 25, 2019

In terms of editing queries there are a couple of settings you can switch off so try these ( see screenshots)

Another question would be how much RAM do you have on your machine. Hopefully at least 16GB.

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?

Wyn Hopkins
MVP
Jan 20, 2020
Hi pdelreal365

I don't have an answer sorry. All I can suggest is that you "Send a Frown" to report this to the Excel team