Table Properties – No Table Preview just Query Editor

[eliwaite]

I am using Office 2016 64 bit and running into a problem with the Table Properties in PowerPivot. When I import a file (from Excel), but forget to include, exclude a column or set a filter correctly on the initial import I use to be able to go to Design->Table Properties and modify the import. Recently though, the only option I get is the Query Editor. Does anyone know how to get the Table Preview back? I created a short video showing what I am running up against if you are having trouble understanding what I am trying to explain https://www.youtube.com/watch?v=H0hoAjG1s4Q&feature=youtu.be

 

[Matt Allington]

Hi Eliwaite. I see 2 other users at PowerPivotForum that seem to have the same issue. Edit Table Properties Problem - PowerPivot Forum

and here

Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016 - PowerPivot Forum

 

[Matt Allington]

I have all 3 versions of Excel with Power Pivot. I just completed a test using all 3. It works fine in 2010 and 2013, but it does not work for Excel 2016. This is a clear bug. You should contact Microsoft support at https://answers.microsoft.com/