Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

Connecting to Akixi API using Power Query

Hi All

I'm new to exploring API's and I'm trying to import data from the Akixi API to pull in telephony data. However I'm having a problem trying to get it to connect as I first need to create a service session and then authenticate the session using basic authentication (username / password). Once the session is authenticated, it must be used as JSESSIONID cookies authentication with all requests. The HTTP method is POST.


Can anyone help point me in the right direction so I can at least start trying to pull in data. Below is a link to the Dev portal explaining about the authentication process.


Any help will be greatly appreciated.

New Member

Hi Sharkman, did you find out how to link Akixi and Power Bi in the end?

Thank you for this. I've been readin through the link but I can't see anything about where you have to create a session first. For this API I need to create the sessionID and then pass this through as a JSESSION cookie to the login step where I can use the appropriate authentication method. Are you able to give an example code of how I would create the session and obtain the session ID token to then pass into the login step.  

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.