I'm trying to create some Dataflows in the PowerBI Service using PowerQuery Online (becuase for some reason there's no option to create dataflows in the desktop app...). One of the files I need to extract data from is an XLSM file hosted on Sharepoint. I use the sharepoint folder connector to locate the XLSM file and then go to "combine files" under the Binary Column in order to access each of the sheets and it comes up with the following error.
I can execute this perfectly for XLSX documents online, and even for XLSM documents using PowerQuery on Desktop. Is there any form of workaround or planned bugfix to allow me to access XLSM files using PowerBI Service? Or am I doing something monumentally stupid?