Forum Discussion
Load to data model incredibly slow
I have an Excel file that uses both Power Query and Power Pivot. Without user input, the file is 2.6MB. The data model has 13 tables, all based on queries of tables internal to the file-- i.e. w...
I have the same issue.
I duplicated the extremely slow query and removed the "Add to data model".
The duplicated query now runs in seconds.
The original query, with loading to data model, takes around a minute.
Why is the adding to the data model so slow?
I duplicated the extremely slow query and removed the "Add to data model".
The duplicated query now runs in seconds.
The original query, with loading to data model, takes around a minute.
Why is the adding to the data model so slow?
In general it shall be no big difference. Without the file it's hard to say what could be the reason. At least be sure in Power Query table data types are declared for all columns, i.e. you have no columns with "any" data type.