Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
@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
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.