Hello.
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.
Bookmarks