Multiple tab dashboard like multi tab reports

[svella]

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

[Greg_Deckler]

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]

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]

@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

[WillT]

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]

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