select multiple sheets from existing excel sheet.

[Bhavana_PB]

I have this excel sheet where there are 5 sheets like items, order, purchase order etc.

Now when i connected to power bi,  i only selected items and clicked on load button. But now i want to go back and select orders sheet also. How do i do it ?? And also I have this region field and i want to convert the datatype to geographical field. Like the way you can do it in tableau. How do i do that too ? 

I cannot find option of editing my dataset. I am very new to power bi. Please help.

[v-qiuyu-msft · Accepted solution]

Hi @Bhavana_PB,

When you get data from the Excel sheet, you can select multiple sheets within one workbook:

To set a geographical field, you can change Data Category as Country/Region:

Best Regards,
Qiuyun Yu 

[Bhavana_PB]

Hi,

But what if I select only one sheet from a excel file, and later on i decided to pull 2 more sheet from same excel file then ? I wanted that editing opition is that option present ?

But thank you for your responses now I can change the  data type of my region. 🙂