Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

cannot load xlsx file

I have recent version of power bi, and have data in xlsx.

 

on the preview, the data appears ok:

 

but when I complete the load, errors arise, and I cannot see the errors, and my data has lots of NULL and errors. Below is a snippet:

 

I cannot upload xls files either, and company policy prohibits me from installing as per https://community.powerbi.com/t5/Desktop/XLS-EXCEL-FILE/m-p/209230#M92275

 

Is there a way to load from xlsx

Need Help

5 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Please check your Excel extension, in Power BI Desktop, both Access databases and early versions of Excel workbooks (.XLS files of type Excel 2007-2003) use the Access Database Engine.

     

    While for the .xlsx extension excel file, you can choose the Excel directly.

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I used those methods and still came up with the error mentioned

      • v-xicai's avatar
        v-xicai
        Community Support
        7 years ago

        Hi Anonymous ,

         

        Try to create a sample data such as 1,2,3, 4,,etc in excel ,and connect it again using the Excel connector, check the result. Based on my test in the latest Power BI Desktop version 2.70.5494.661 , it worked fine.

         

        Best Regards,

        Amy