Forum Discussion

pstanek's avatar
pstanek
Post Patron
9 years ago

Direct Query and (slicer)import Excel

I use direct query  and I have list of product in Excel that  I want to analyse. How will I do it?
Need Help
Show and Tell
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi pstanek,

 

Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1 GB.

 

What's your issue currenly? Please providue us more detail information, so that we can make further analysis.

 

Reference
Get data from Excel workbook files

 

Regards,

Charlie Liao

  • pstanek's avatar
    pstanek
    Post Patron
    9 years ago

    But you can choose between Direct query nad import data form Excel, but Not at the same time.

    I have many problems beacause i can´t find enough information about direct query.

     

    If I  choose import data from excel, I will loose contact with my database in MS Azure.

     

    So I don´t ask if i can  import data from excel, I ask how I can analyse excel sheet by using data in direct query.

     

    Someone give me excel sheet with 50 products.  I have data  about 10 000 - 100 000 products in MS azure, so we have direct query connection . I want to analyse this 50 products.

     

    Precisely when your are in direct query a you are trying to import Excel workbook. It wants to download entire MS Azure database to computer.