Connecting from Tableau Desktop
The instructions on this page are based on Tableau Desktop Professional Edition 2020.3.6.
The Windows version of Tableau Desktop Professional Edition is required to connect to Open Data Blend Analytics.
We recommend using Tableau Desktop Professional Edition 2020.3.6 or later for the best experience.
We recommend installing the latest version of the Analysis Services OLE DB Provider (MSOLAP). This is available here.
In the Connect pane under the 'To a Server' section, click 'Microsoft Analysis Services'.
You will be prompted for the connection details.
Enter the following details then click 'Sign In':
Username: Enter a blank space.
Password: Enter a blank space.
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'
You will be prompted to sign into your account. Use your Analytics User details and follow the additional prompts to complete the login.
On the data source page, select 'Open Data Blend Analytics' for the database and 'Model' for the cube. Then click 'Sheet 1'.
If you want to work with only a subset of the model, you can choose one of the other cube names. For example, if you want to focus on analysing the prescribing data you would choose 'Prescribing'.
Now you can analyse the data.
This is what the Open Data Blend Analytics experience looks like in Tableau Desktop.
Guidance on how to analyse data in Tableau Desktop is beyond the scope of this documentation.
You may find the following helpful:
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 Tableau Desktop here.