Power BI Data Access, Transformation and Cleansing

Expand all | Collapse all

Problem importing .xls files from folder

  • 1.  Problem importing .xls files from folder

    Posted 12-13-2018 07:03 PM

    Hello everyone.

    I've been importing singular .xls files without any issues but whenever I try to import them contained in a folder I get the following error messages.

     

     

    Error on Power BI editor

     

    The files that I'm working with are being created by an old software running in a 32bit machine which allows data to exported into .xls files.

     

    After doing some digging I found out that if I open said files on my machine, running 64bit Excel, and save the file (overwritting it) I'm able to import them on Power BI.

     

    My goal is to have everything automated so I was wondering if any one has a better solution. One which won't force me to open each .xls file and overwrite it on a 64bit machine.

     

    Thank you. All the best,

    Lobo



    ------------------------------
    Paulo Lobo
    Animal Nutrition Advisor
    paulo.lobo.santos@gmail.com
    Porto
    926043584
    ------------------------------


  • 2.  RE: Problem importing .xls files from folder

    Bronze Contributor
    Posted 12-15-2018 12:46 PM
    Edited by Mehdi HAMMADI 12-16-2018 02:44 AM
    Hi Paulo,
    Try it with a 32 bits version of the PBI Desktop, I learned that every peace of your import process have to be on the same architecture. (Using R in Power BI - Object reference not set to an instance of an object error !!! )

    ------------------------------
    Regards
    Mehdi HAMMADI
    ------------------------------