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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Sharkman60
Regular Visitor

Connecting to Akixi API using Power Query

Hi

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.

https://akixi.dev/api/external/rest/v1/endpoints/auth/auth.html#create-session

 

Any help will be greatly appreciated.

2 REPLIES 2
foodd
Community Champion
Community Champion

Would you please consider moving this post involving API usage to the Microsoft Power BI Community Developer Forum, where they focus on the following:  Custom visual creation, API usage, real-time dashboards, integrating with Power BI, content packs. Basically, everything about extending Power BI.


https://community.fabric.microsoft.com/t5/Developer/bd-p/Developer

No problem. I've tried editing but I don't think I can move category. Shall I just do a new post within the Developer section?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors