New data base filed not transferring to Powerpivot on refresh

[StewartS]

Hi

I'm currently just looking at converting some of my reportng from Access and Excel to using Powerpivot - which does seem the way forward. I've realised that to make the details work better I needed an extra column in one of my Access tables which is linked Powerpivot. The problem is that the new column does not show up when I refresh the data. I don't want to reimport the data as I have a number of details that link into the table.

I've tried looking for the problem but can't seem to find anything.

Can anybody help please.

StewartS

 

[ruve1k]

Edit the table properties, then on the drop-down on the top right change it from Table Preview to Query Editor ans ensure that the new column is listed.

 

[StewartS]

Thanks - I can see I might need to learn some basic SQL for this.