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...

Data Modeling

v-robertq-msft

Community Support

5 years ago

Hi,

According to my research, here are some related cases, you can take a look and check if they are useful:

https://community.powerbi.com/t5/Power-Query/open-file-as-text/td-p/683214

https://community.powerbi.com/t5/Desktop/Error-combining-files-in-Power-query-from-Azure-Datalake-despite/m-p/566325

https://community.powerbi.com/t5/Desktop/Unzip-and-load-csv-from-web-error-quot-we-didn-t-recognize-the/m-p/646849

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

Completed Ideas

Set as landing page feature missing in Apr 2026 update (Build 2.153.1206.0) both in Desktop and Serv
Input Slicer Bug: Cursor jumps to position 0 and values cannot be cleared in Service
Input Slicer Causing Browser Tab Freeze in Public Links (Started April 24, 2026)
Small multiples not fitting to scale
Previously working Mac calender visual now gives me a error every time I touch it!
Text Slicer does not reset via Bookmarks or Clear All in Power BI Service (Service-only behavior)
Text Input Slicer is not reset by bookmarks in Power BI Service while working correctly in Power BI
Azure maps not displaying mapped data points in publish to web when location used
Azure Maps reference layer transparency behaves differently after publishing to Power BI Service
Desktop Application Bug?? - PBI desktop application left navigation icons always solid black