LMS

Learn how to connect an SharePoint Excel Files to Power BI using the Power BI web connector step by step. Also, learn how to connect a SharePoint Folder to Power BI and merge all of the files together step by step. Lastly, learn how to automate Form Responses to Excels hosted in SharePoint step by step.

In order to automate converting excel file types, we can use scripting languages such as Python or PowerShell.

The script in this article converts all of the XLS files in an existing folder to XLSX files, also making sure to delete any previously existing XLSX files that were in the folder previously.