Accessing Real Time trips API through Power BI

1

HI gurus

Could you please help in connecting to ‘https://api.transport.nsw.gov.au/v1/gtfs/realtime/sydneytrains’ from Power BI.

I am using my apikey as the header in the web connection settings. However i get an Details: “Unable to connect to the remote server” error. Kindly help.

2

That error sounds unrelated to the key. Do you have any more details?

3

Hi Jayen

The error i posted was for Power BI desktop on my laptop. Tried using another laptop and i was being prompted to enter User Authentication details. I was trying to use Web as the data source.It prompted for authentication details and didnt work.

I used api url with header Authorization and the apikey.

4

ok, so it sounds like there was a connection issue on the first laptop, and you got further on the second laptop.

the Authorization header value is formatted with the word “apikey”, then a space, then the actual API key. There is an example here: Using an API Key

Do you know if Power BI is setting the Authorization header as required by the API? It may just be setting it to the API key (without the word “apikey”).

5

HI Jayen

I reinstalled PowerBI and the connectivity issue was resolved. Thank you for your tips.

However i am not able to understand the output response from the query.I might be doing it wrong.Now the challenge is to read the response within PowerBI.

6

this may be related: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17057890-add-import-support-for-protobuffers

1 Like
7

Thank you . I will explore this …