Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Good morning to everyone,
I've a set of files allocated in SharePoint. Those files are .xls files, which means, Excel 97-2003. Due to a variety of reasons I'd like those to be converted to .xlsx format. My question is, is there any way to read those files using Power BI and convert them to .xlsx before importing them into tables?
Many thanks
Solved! Go to Solution.
Three potential approaches to consider:
1. Use the xls files in Power BI as is (be aware that xls can be a problem - Avoid Using Excel XLS Files As A Data Source — ehansalytics
2. Use Power Automate Desktop to create a UI flow to batch convert them
3. Use R or Python to do it (technically you could do it through the R/Python integration in Power BI Desktop to read in the xls file and write xlsx to local disk, but it wouldn't be part of normal refresh).
Pat
Thank you! Finally we coded a Python script 🙂
Three potential approaches to consider:
1. Use the xls files in Power BI as is (be aware that xls can be a problem - Avoid Using Excel XLS Files As A Data Source — ehansalytics
2. Use Power Automate Desktop to create a UI flow to batch convert them
3. Use R or Python to do it (technically you could do it through the R/Python integration in Power BI Desktop to read in the xls file and write xlsx to local disk, but it wouldn't be part of normal refresh).
Pat