Forum Discussion
Solved
Loading an Excel spreadsheet with script
I need a script (PowerShell, VB, C#, etc) to load an excel spreadsheet to my Power BI Report Server. Can someone help?
There is a set of PS modules you can use. https://github.com/microsoft/ReportingServicesTools
2 Replies
- To start off we can use the SpreadJS files hosted on NPM. To do this, we can install using command line argument. Open up a command prompt and navigate to the location of your application. There, you can install the required files with one command. In this case, we need the base Spread-Sheets library, Spread-ExcelIO, and jQuery:
bradsyMicrosoft Employee
There is a set of PS modules you can use. https://github.com/microsoft/ReportingServicesTools
