Forum Discussion
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...
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.
Hello Wyn,
I'm using Office 365 - Excel version 1912 and I'm experiencing the same issue.
The original Query is set to create just a Connection (no actual table loaded into excel tabs).
When the data source is changed, the updated data is getting OK to the POWER QUERY preview just with a single Refresh, but it fails to update the Data Model when Refresing Power Pivot.