Small problem I'm having with power queries. I need to get a Distinct Count in a pivot table, but in order to get that, I need to have the data added to the data model it seems.

However, if I run a New Query, load a csv or xlsx (workbook) file, edit the data and then select the "Close & Load To..." option, I see that the "Add this data to the data model" option is blanked out. Why is this happening? How can I select it?

Thanks for any help. Excel version is 2016.