Forum Discussion
Added new tab to excel core data and does not appear when refreshing
first where to find the data:
you need to go to the steps list for your table, to the step that links to Excel - you should see new sheet listed there
the next step is by default named Navigation - that's where the script goes to a specific sheetwhat you can do is instead of navigating to a single sheet is following:
1) filter only for the sheets you will need
2) remove all columns but the one named Data
3) expand the 'Data' column
that will merge the data from all the sheets
other option is to right click on the Table you miss and press add as a new query
it will create a copy of the M script as a new query but pointing to a new sheet
then you can append that table to your original table
Community Championfirst where to find the data:
you need to go to the steps list for your table, to the step that links to Excel - you should see new sheet listed there
the next step is by default named Navigation - that's where the script goes to a specific sheet
what you can do is instead of navigating to a single sheet is following:
1) filter only for the sheets you will need
2) remove all columns but the one named Data
3) expand the 'Data' column
that will merge the data from all the sheets
other option is to right click on the Table you miss and press add as a new query
it will create a copy of the M script as a new query but pointing to a new sheet
then you can append that table to your original table
Thank you - passed the message onto my colleague and he says the advice put him in the right direction so thank you for your help and guidance. P