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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SimonJBrown
New Member

Pull data from a REST API which has Authentication

Hi

New to PowerBI so please forgive me if query does not make complete sense!

I have PowerBI Desktop and want to get date from a REST web service.

 

The issue I have is the web service requires an authentication first, before I can call the methods for data I want.

The product is Traverse.

 

So, to logon I first have to issue command like;

http://hostname/api/rest/command/login?myusername/MyPassword

 

This authenticates me and returns success if logged on, I see in POSTMAN that a cookie is created for session.

 

Once I have done that I can call upon its many methods to pull data out, these are the methods I need access to for PowerBI

e.g.

http://hostname/api/rest/command/sla.status?slaSerial=2022436&calculationPeriod=Day&startTime=201803...

to get me json back with report data I want to pull into PowerBI to then produce charts and such

 

What I cannot see is a method to call the second URL without the authentication. The Get Data from Web source does not seem to accomodate this type.

Is there a way to do this with the Advanced Editor?

 

Thanks in advance

 

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@SimonJBrown,

Please verify that if your web service supports "Basic" authentication or some headers such as subscription key, it is possible to use these authentication types in Advanced Editor.

There is a blog for your reference.
https://jessedotnet.com/2016/06/24/power-bi-connect-to-your-secure-api/

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi!

 

fyi, the link provided by @v-yuezhe-msft is not working anymore.

 

Cheers. G.

I have posted query on Traverse community site but not had a response. From their developer guide it looks like the only option I have is the URL to logon as a pre step to the data URL request as described in opening post.

 

I may have to write a wrapper web service so I can send request through, do the URL authentication and request before returning data. Didnt want to do that as time consuming and additional overhead.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors