Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Reading files from SharePoint and changing format files

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 ...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    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

     

ppm1's avatar
ppm1
Solution Sage
3 years ago

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