Hi - I just installed the 64bit Excel 2016 and used power query to query data from access database (mdb file). When I try to load it into the data model, I get a "download failed" with the following message "[DataFormat.Error] Unspecified error"
I am guessing this is some non-compatibility issue between 64bit Excel 2016 and mdb files. Desperately looking for a fix. Any help would be appreciated.