Read Data from SharePoint List to SQL Server

I followed this blog for one of my use-case. It helpful.

http://whitepages.unlimitedviz.com/2014/03/using-the-odata-source-connector-with-sharepoint-online-authentication/

Run Excel from Windows Credential to Connect SSAS Cube

Option 1:

Create batch file using these below script

@echo off
SET /P username=Please enter the your username:  

runas /netonly /user:DAS\%username% "C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE"

Step 1- Copy the above script in notepad and modify as per your Domain name and Path of Excel exe.

Step 2- Save as batch file e.g "Run_Excel.bat"

Step 3 - now double click the batch file to run the excel and provide the name and password

Option 2:

Also you can run the script directly in Powershell

runas /netonly /user:DAS\Liyas "C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE"


by doing this you can run the excel in Windows credentials and connect the Analysis Service Cube.