Skip to content
More support Customer portal
  • There are no suggestions because the search field is empty.

Connect Customer Alliance Data to Power BI

You can connect your Customer Alliance data directly to Power BI to create interactive reports and dashboards. Follow the steps below to set it up.

 

Step 1: Open Power BI Desktop

Start by opening Power BI Desktop on your computer.

 

Step 2: Get Data from the Web

  1. In Power BI, select Get Data → Web.

In the URL field, enter your API endpoint.

For example, to retrieve reviews:

https://api.customer-alliance.com/v1/reviews?api_key=YOUR_API_KEY

  1.  You can find more query options in our API V2 documentation.

 

Step 3: Request Your API Key

You’ll need an API key to access your data.


Contact our Support Team at support@customer-alliance.com and we’ll generate one for you.

We can provide:

  • A Location Key – for a single location

  • A Chain Key – for all locations in your account

 

Step 4: Access Answers to Specific Questions (Optional)

If you want to include specific question responses (for example, “Which location have you visited?”), use the questionAnswers endpoint from our API V3.

 

Step 5: Load and Visualize Your Data

  1. Authenticate using your API key if prompted.

  2. Load your data into Power BI.

  3. Create and customize your reports as needed.

 

💡 Tip

To keep your dashboards current, refresh your Power BI data periodically.