The following details outline how to connect to the Rapport3 data cubes using Power Query which comes as part of Microsoft Excel 2016.
If you are using an older version of Microsoft Excel (2010 Professional Plus or 2013) please download and install “Microsoft Power Query for Excel” from the following link: https://www.microsoft.com/en-gb/download/details.aspx?id=39379 before continuing with this connection guide.
- Navigate to the Rapport3 Mobile page by selecting the avatar on the top right-hand side of the page:
- Copy the Login Name and Pass Code fields:
- Open Excel and select Data > New Query > From Other Sources > From OData Feed
- Enter https://cubes.rapport3.com into the textbox and click OK. You will be presented with the Authentication dialog. Select “Basic”.
- Enter the “Login Name” field from the Rapport3 Mobile page into the “Username” field in Excel. Enter the “Pass Code” field from the Rapport3 Mobile page into the “Password” field in Excel.
- Finally Click the “Connect” button, to connect to the Data Cubes.
- You will be presented with a list of Tables to Query. Select the Item and Click Edit
- The following website contains useful help articles from Microsoft on getting started with Power Query if the tool is unfamiliar to you. https://support.office.com/en- gb/article/Microsoft-Power-Query-for-Excel-Help-2b433a85-ddfb-420b-9cda- fe0e60b82a94
- You can also connect to the Rapport3 Data Cubes using Microsoft Power BI which also uses the Power Query tool.