Feb 17 2023 03:26 PM
I have an Excel file that uses both Power Query and Power Pivot. Without user input, the file is 2.6MB.
The problem table has 6 columns:
ID, integer
FY, integer
Date, date
VA, currency
VF, currency
None of them are calculated. The table has no measures or relationships. Why does it load so slowly?
Feb 18 2023 06:50 AM
If on copy of the file you remove all queries but this one, is it still slow?
Feb 20 2024 11:23 AM
Feb 21 2024 12:28 AM
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.