How to Connect EQuIS to Power BI

<< Click to Display Table of Contents >>

Navigation:  Power BI Data Connector >

How to Connect EQuIS to Power BI

EQuIS users assigned to the REST API role (in Enterprise) can access data from an EQuIS 7 Enterprise site in Power BI Desktop by completing the following steps.

 

1.Open Power BI Desktop.

2.Click the Get Data button on the Home ribbon. Select More to open the Get Data window.

3.On the side menu, select Other or enter "EQuIS" into the search box. Select EQuIS (Beta).

PBI_PowerBI-Get_Data_Connect

PBI_PowerBI-Get_Data_Connect_More

4.Click the Connect button to connect with an EQuIS Enterprise URL.

5.Connection to EQuIS is through an EQuIS Enterprise site, not directly to an EQuIS database. An SQL database connection string will not work. Enter the desired EQuIS Enterprise URL and click the OK button.

PBI_PowerBI-Enterprise_Connection-OK

 

User Authentication

 

Three methods of user authentication to the EQuIS Enterprise site are supported: (1) Basic, (2) API Token, and (3) Organizational account.

PBI_PowerBI-Authentication_Basic

Basic – Enter your EQuIS username and password for the Enterprise site.

 

API Token – Users assigned to the REST API role can generate a token in the User Profile Editor in EQuIS Enterprise.

 

Organizational account – If the Enterprise site is appropriately configured, users may be authenticated with Azure Active Directory (or what is known as your Office 365 organizational account).