Forum Discussion

svella's avatar
svella
Regular Visitor
10 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 t...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 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
10 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
    Icon for Microsoft Employee rankMicrosoft Employee
    10 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