Skip to main content

Microsoft Power BI Desktop

Requirements​

Before integrating the MindKey Connector API with Microsoft Power BI Desktop, ensure you meet the following requirements:

  • Microsoft Entra ID User Account: You must have configured a Microsoft Entra ID user account to authenticate and authorize API requests.
  • Download Microsoft Power BI Desktop from the Microsoft Store
  • An additional license from Microsoft might be needed to use Microsoft Power BI Desktop

Steps for Integration

Step 1: Open Microsoft Power BI Desktop and Access Power Query​

  • Open Microsoft Power BI Desktop.
  • Navigate to the "Home" tab.
  • In the "Data" group, click on "Get Data".
  • Search for "OData Feed" and click on "Connect"

Step 2: Enter the OData Service URL​

Step 3: Authenticate Using Microsoft Entra ID​

  • If prompted for authentication select "Organizational Account"
  • Click on "Sign in" and authenticate using your Microsoft Entra ID credentials.
  • After signing in, click on "Connect"

Step 4: Load and Use Your Data​

  • Once Microsoft Power BI Desktop successfully connects to the MindKey Connector, select the tables or fields you need.
  • Load the data into Excel for further analysis or reporting.