How to add additional tabs from existing excel spreadsheet data source?

[indyb]

Hi all, 

I have a excel spreadsheet which has a number of tabs.

I am currently using this file as data source for my Power Bi and using 1 of the tabs, however I would now like to also use a few of the other tabs as tables. 

How can I add these in? I am struggling to find how to do this on the Query editor, and when I try to add the data as a new source, I cannot as it is already in use.

Many thanks in advance for your help! 

Indy 

[indyb · Accepted solution]

All sorted now guys and was able to add the addtional tabs. 

The issue was silly - it was a shared document and one of my collegues had it open so would not allow me to access. I didnt realise it was shared so was struggling to understand why it wouldnt work even though I didnt have it open! 

[amitchandak]

@indyb 

When use a excel to Power BI , it shows each sheet or Table a new table to add

[danno]

There shouldn't be anything stopping you from importing data from another tab, can you screenshot the error? 

[danno]

you should be able to go to Get Data from Excel and select the other tab.  Alternatively go to Existing sources and again select the other tab