Forum Discussion
Power Query for Binary
Team,
Lately I have been stuck with one situation… every month I have to consolidate around 250 excel files which are in binary format. All these files are with same header and all. I tried to use power query for this but it throw me error every time. My guess is this is due to format of excel.
Alternatively, I can also have those files in csv format but one column in csv format has link embeds to internal site and everytime I try to combine via power query that column shows only link and not value.
Do you have any suggestion here which can make my work little easy.
1 Reply
Hello ashishadh !
Could you add screenshot of the error message and also add an exemple of the Excel files you are trying to consolidate (or at least tell what kind of extension it is (.xls, .xslx,.xslm, .xlsm)) ?
Have a good day !
Nicolas
