Power BI Data Access, Transformation and Cleansing

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Problem importing .xls files from folder

  • 1.  Problem importing .xls files from folder

    Posted Dec 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

    Gold Contributor
    Posted Dec 15, 2018 12:46 PM
    Edited by Mehdi HAMMADI Dec 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
    ------------------------------