Status:
New
Datflows are not supporting .xlsm file format for combining query
Dear Team, I have to connect to a sharepoint folder to combine multiple excel files. File extension of all the files in the folder is .xlsm. When i use Data flow to connect to this folder and comb...
Still Looking for solution from Power BI developers, no response from them. Its a very immature behaviour of Dataflows that they do not consider .xlsm as an Excel file.
atleast from the functionality point ETL process should be consistent across Power BI, Excel and Data Flows.
As a WA, i am using a flow to copy those files in a different folder at periodic intervals and changing the extension to .xlsx :). That works. You can search Google for creating such a FLOW.
Regards,
Divesh Goyal