Refresh Code Adds Table Columns

[billy60]

Hello,

What determines how many table columns are included when running the Refresh code?

I want to customize the table on the Movies sheet to only have the ID, Movie Title, and Genre. Also have the ability to select which columns to have.

Is it possible to have the ability to select which table columns to have on the Movies sheet which gets the information from the Data sheet?

Thank you for your help

[billy60]

The table was based on a query. I edited the query to only include the columns that I needed. Now it works how I wanted.

[billy60]

I have much to learn about the power query.