Open Data Blend Docs
  • Introduction
  • Open Data Blend Datasets
    • Datasets
    • Dataset Versions
    • Dataset UI
    • Dataset API
    • Frictionless Data Compatibility
    • Modelling Conventions
    • Loading Data Files in Excel
    • Loading Data Files in Power BI Desktop
    • Loading Data Files in Tableau Desktop
    • Loading Data Files in Python
    • Loading Data Files in R
    • Loading Data Files in Other Tools
  • Open Data Blend Analytics
    • Analytics
    • Analytics Queries
    • Analytics Users
    • Connecting from Excel
    • Connecting from Power BI Desktop
    • Connecting from Tableau Desktop
    • Connecting from Other Tools
  • Open Data Blend Insights
    • Insights
    • Report Drill Throughs
    • Report Drill Downs
  • Subscription Management
    • Subscription Portal
    • Managing Analytics Users
    • Managing Access Keys
    • Updating Payment Details
Powered by GitBook
On this page
  • Supported Power BI Versions
  • Connecting to the Open Data Blend Analytics Server
  • Open Data Blend Starter Files

Was this helpful?

  1. Open Data Blend Analytics

Connecting from Power BI Desktop

PreviousConnecting from ExcelNextConnecting from Tableau Desktop

Last updated 1 year ago

Was this helpful?

The instructions on this page are based on the Power BI Desktop February 2021 release.

Supported Power BI Versions

The Open Data Blend Analytics database is hosted in Azure Analysis Services. We recommend that you use the latest version of Power BI Desktop to connect to Open Data Blend Analytics.

Connecting to the Open Data Blend Analytics Server

On the Power BI ribbon, click Get Data > Analysis Services.

You will be prompted for the connection details.

Enter the following details and ensure 'Connect live' is selected then click 'OK'.

Server: link://analytics.opendatablend.io

Database: Leave blank.

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.

When presented with the 'Navigator' screen, expand 'Open Data Blend Analytics', click 'Model', and then click 'OK'.

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'.

Now you can start analysing the data.

This is what the Open Data Blend Analytics experience looks like in Power BI Desktop.

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 Power BI Desktop here.