Forum Discussion

svella's avatar
svella
Regular Visitor
9 years ago

Multiple tab dashboard like multi tab reports

Hello,

 

I have a datasource that was connected via an excel sheet on ondrive.  Originally the excel sheet had 1 tab. I have added a second tab and no matter how many times I refresh, I cant seem to get the second tab fileds to show up.

 

Is there a step by step on how to introduce new tabs from excel into Power BI ?

 

Thanks

5 Replies

  • WillT's avatar
    WillT
    Community Admin
    9 years ago

    I'm assuming you're using the Power BI Desktop here?

     

    When you hit refresh it's just looking for new data in the table/range you initially imported. You'll need to create a second connection to that workbook for the data on the second sheet. You can use the Query Editor to merge or append the two sheets together if you want it to appear as a single table in Power BI, and you can use the Query Editor to load them dynamically as well if you don't know how many sheets will have data in the future.

     

    HTH

    Will

    • svella's avatar
      svella
      Regular Visitor
      9 years ago

      Hi,

       

      Yes I am using Power Bi Desktop.  When I try to create a second connection I still dont have my second page show up as an option no matter how I query it. It seems to keep using the first connection and only showing the one tab.

       

      Not sure where to go from here. 

       

      Question ?  In the event I want to take an exiting reporting and reaim it to a new excel sheet without breaking all the work I did in the report is this supported.  I did a test earlier and it seems even when I use a copy of the original excel sheet, it will break.

       

      Thanks

       

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    I just tested this and it worked flawlessly. I had an Excel spreadsheet in OneDrive for Business. I Connected this spreadsheet to Power BI. You know it is Connected if it only shows up in Reports with a little Excel icon next to it. If you Import it, you will get a dataset. I went into One Drive for Business and added a tab in Excel Online. I went back to Power BI and did a "Reload" (not Refresh) and the new tab showed up.

    • svella's avatar
      svella
      Regular Visitor
      9 years ago

      Ok thanks for the confirmation. I get the sense that it works more reliable from the web version.  I am using power Bi desktop and having the issue importing the second sheet.

       

       

      • v-haibl-msft's avatar
        v-haibl-msft
        Microsoft Employee
        9 years ago

        svella

         

        Did you get the second sheet of the excel file in Query Editor as below? I can get the data imported once I add a second sheet and save the excel file.

         

         

        Best Regards,

        Herbert