Connecting from Excel
Last updated
Was this helpful?
Last updated
Was this helpful?
The Windows version of Excel 2019 or later is required to connect to Open Data Blend Analytics.
You may need to install the latest version of the Analysis Services OLE DB Provider (MSOLAP). This is available .
Navigate to the 'Data' tab in the Excel ribbon and click Get Data > From Database > From Analysis Services
.
You will be prompted for the connection details.
Enter the following details and select 'Use the following User Name and Password' then click 'Next':
Server: link://analytics.opendatablend.io
Username: Leave blank.
Password: Leave blank.
When prompted to 'Select Database and Table', the 'Open Data Blend Analytics' database, click 'Model' then click 'Next'.
On the 'Save Data Connection File and Finish' step, update the data file name and friendly name if needed, then click 'Finish'.
On the 'Import Data' dialog, click 'OK' to proceed with creating a PivotTable that is connect to the Open Data Blend Analytics Model.
Now you can start analysing the data.
This is what the Open Data Blend Analytics experience looks like in Excel.
You will be prompted to sign into your account. Use your details and follow the additional prompts to complete the login.
We have created a set of Open Data Blend Starters which are files with a pre-configured connection to Open Data Blend Analytics. You can find the starter for Excel .