Sign in

Articles in this section

  1. Coruson
  2. Using Coruson
  3. Galileo

How to Connect to Galileo Using Microsoft Power BI

Alan Blair
  • Updated
Follow
Who is this article for?

 Coruson administrators or data scientists.

 Access keys for Galileo are required.

Galileo is Ideagen's data warehouse for Coruson, which allows you to connect and perform your own analysis of your Coruson data.

This article outlines the steps required to connect to Galileo using Microsoft Power BI. This does not provide details on specific steps on how to perform the data analysis as these steps vary depending on the tools you use.

To make connecting to Galileo easier to learn, this article is split into 4 sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are doing with Galileo:

  1. Install Microsoft Power BI
  2. Connect Using Power Query
  3. Further Reading
Before you proceed, please ensure you have your data warehouse URL and the access keys for Galileo. For details on how to request these please visit How to Request Galileo Access.

1. Install Microsoft Power BI

If you don't already have Power BI installed then it can be downloaded for free from the Microsoft Store:

  1. Browse to the Power BI Desktop page of the Microsoft Store.
  2. Click Install.

mceclip0.png

More Assistance: For more assistance in installing Microsoft Power BI please visit the Microsoft Power BI website.

2. Connect Using Power Query

With Power BI installed and your keys on hand you are ready to connect to Galileo.

To connect:

  1. Open Microsoft Power BI.
  2. Click Get Data.
  3. Select Blank Query and then click [Connect].

mceclip1.png

  1. Click Advanced Editor (located in the Query section of the Home ribbon).
  2. Enter the below power query code:
let
 Source =OData.Feed("https://tenant.ideagendata.com/odata/", null,
 [
 Headers = [#"X-IdeagenDataAPIKey"= "ACCESSKEY" ]
 ])
in
    Source
  1. Update the code with your tenant and access key.
  2. Click [Done].

Once connected you can see the full list of table views available within Galileo.

3. Further Reading

Article Comments

0 comments