Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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! 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous 

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