Importing Excel from OneDrive Business

[weda9001]

Hi,

Apologies if this is a stupid question - however, I am just getting started in PowerBI and am trying to import an Excel worksheet that is stored on OneDrive for Business.

I am able to import the file however when I go to the report builder, I am only able to see my first tab as a data set available. My excel worksheet has several tabs and its actually the 2nd tab that I want to use for building reports.

Can anyone tell me what I am doing wrong?

[v-jingzhang · Accepted solution]

Hi @weda9001 

If you are using Power BI Desktop, please follow this document to import data from an Excel file in Onedrive for Business. Once you connect to the file successfully, you can select any sheet in the Navigator window just like below. 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Mohammad_Refaei]

Obviously you imported the first sheet.

In Power Query go to Advanced Editor and edit the lines similar to the below:

Source = Excel.Workbook(File.Contents("\\LongAddress\YourFile.xlsx"), null, true),
NextStep = Source{[Item="YourDesiredSheetName",Kind="Sheet"]}[Data]