Question

You are importing a Sales fact table into Power BI Desktop. The table contains 12 million rows and a Transaction GUID column that holds a unique text identifier for every row. The report never filters, groups, or displays individual transactions by this GUID, but the imported model file is very large and slow to refresh. In Power Query, what should you do to reduce the model size while preserving all analytical capability?

Accepted Answer

Remove the Transaction GUID column from the query before loading

Answer

Change the Transaction GUID column data type from Text to Whole Number

Answer

Add an index column to replace the Transaction GUID as the key

Answer

Set the Transaction GUID column to load but disable its refresh