Forum Discussion

Bhavana_PB's avatar
Bhavana_PB
Frequent Visitor
8 years ago
Solved

select multiple sheets from existing excel sheet.

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 ba...
Custom Visuals
Dashboards
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    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 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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's avatar
    Bhavana_PB
    Frequent Visitor
    8 years ago

    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. :)