Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 combine all the .xlsm files it throws an error as below in th esnapshot.
I am able to combine these files with the help of the Power BI desktop as well as with the help of the Power Query in Excel.
Kindly help me to solve this issue.
Any workaround to solve this issue would also be welcome.
Best Regards,
Divesh Goyal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.