I can’t access entire columns of data that I'm loading in from an Excel sheet. Basically, a few of the columns from the Excel file show up like this (faded/grayed out) in the data source tab. All the data is there and correct but I can't use any of it.
They’re similarly faded in the Measures box. I can’t use any of these faded out Measures – they can’t be clicked or dragged.
The columns are not available because are hidden.
Right click on the grayed out column/s and select "Unhide".
Hope this help