DGDhivyabharathi Govindaraj Syncfusion Team September 19, 2019 01:49 AM
Files type connection and Web data source types connection will be enable only when the Data Store settings information are saved in the Dashboard Server application. To enable the Excel connection, follow below steps.
In the Data Sources window click the Settings link to open the Data Store Settings window.
In the Data Store Settings window, configure your SQL credentials (like server name, user name and password) then click “Save” button to save your credentials.
Once the Data Store Settings information is saved, go back to your designer page and click “Refresh” icon like as below.
Now Excel connection type will be listed in the Data Sources. Click Excel and connect your Excel sheet in Designer.
Kindly let us know if you need any further assistance.