# Connecting from Excel

{% hint style="info" %}
The instructions on this page are based on Excel 2019.
{% endhint %}

## Supported Excel Versions

The Windows version of Excel 2019 or later is required to connect to Open Data Blend Analytics.

## Installing the Analysis Services Client Libraries

You may need to install the latest version of the Analysis Services OLE DB Provider (MSOLAP). This is available [here](https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions).

## Connecting to the Open Data Blend Analytics Server

Navigate to the 'Data' tab in the Excel ribbon and click `Get Data > From Database > From Analysis Services`.

<div align="left"><img src="/files/-MULFJn7FKOFtMDFjlSe" alt=""></div>

You will be prompted for the connection details.

<div align="left"><img src="/files/-MULFZ0zAOa4x8A8BEa9" alt=""></div>

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.

{% hint style="info" %}
Instead of 'link://analytics.opendatablend.io' for the server, you can also use 'powerbi://api.powerbi.com/v1.0/analytics.opendatablend.io/Open Data Blend Analytics'
{% endhint %}

You will be prompted to sign into your account. Use your [Analytics User](/open-data-blend-analytics/analytics-users.md) details and follow the additional prompts to complete the login.

<div align="left"><img src="/files/-MUVKppRQKrrZ4FXhQO0" alt=""></div>

When prompted to 'Select Database and Table', the 'Open Data Blend Analytics' database, click 'Model' then click 'Next'.

<div align="left"><img src="/files/-Mkwfop7nXmh1eqWsL-3" alt=""></div>

{% hint style="info" %}
If you want to work with only a subset of the model, you can choose one of the perspectives (i.e. a named subset of the model). For example, if you want to focus on analysing the prescribing data you would choose 'Prescribing'.
{% endhint %}

On the 'Save Data Connection File and Finish' step, update the data file name and friendly name if needed, then click 'Finish'.

<div align="left"><img src="/files/-MULIH6k9Rf_rVtR1_xf" alt=""></div>

On the 'Import Data' dialog, click 'OK' to proceed with creating a PivotTable that is connect to the Open Data Blend Analytics Model.

<div align="left"><img src="/files/-MULIYDkF5HBjd4BnieK" alt=""></div>

Now you can start analysing the data.

<div align="left"><img src="/files/-MULJHea1Hb3HMo-GIwL" alt=""></div>

This is what the Open Data Blend Analytics experience looks like in Excel.

![](/files/-MbtgT679MqdkxpuLDt0)

## Open Data Blend Starter Files

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 [here](https://github.com/opendatablend/starters).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.opendatablend.io/open-data-blend-analytics/connecting-from-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.