Added new tab to excel core data and does not appear when refreshing

[Tomo2709]

Hi

I am using power BI desktop and i have created a PowerBi report and associated data which is stored on SharePoint.  I have added a new tab to the spreadsheet data, but this does not show in the PowerBi field when i refresh Power Bi.

How do i refresh the report to take account of the new excel worksheet?

Many thanks

P

[Stachu]

you need to add the new **bleep** in the query editor, normally ir links to specific sheet as defined in the process
if you expect it to happen more often you could consider getting data out of all sheets in the file, this should be doable as long as new sheets would have exactly the same structure

[Tomo2709]

Hi - thanks for responding - when i am in query editor do you mean add a data source - as the data source is still the same - all i have done is add a new worksheet  to the core excel data but that does not show in power BI - sorry i may be just not getting this but if you could go into a little more detail that would be fantastic.  many thanks  Paul 

[Stachu · Accepted solution]

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 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

[Tomo2709]

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