Access JSON generated by API in internal appication, Windows credentials & apiKey

[marcin_wozniak]

Good afternoon

We want to use PBI Service to pull data from our internal system. The data is generated by the system into a json file, let's say the address is  http://system1.ourdomain/api/range.json

The address is visible only from within our corporate network.

To access the range.json, I have to provide my Windows credentials and pass the apiKey in the Header of the request. 

Once the connection is made, I want to install an on-demand gateway on a server, establish the connection there and plan scheduled refresh of data.

Now, I cannot make it work in PBI. From PBI desktop,

• I am selecting "Web" as data source
• I put http://system1.ourdomain/api/range.json as the URL
• in HTTP request header parameters I put the apiKey and the value

This generates an error - PBI can only use custom headers when the address is accessed anonymously. I cannot use Windows login with it.

What should I do to make the abovementioned scenario work? Either with the way my internal application grants access to the API, or through PBI configuration?

many thanks

M.

[Anonymous]

@marcin_wozniak,

Is it possible to access the root URL of your application anonymously? If so, add RelativePath paramater into the code of Advanced Editor of the query in Power BI Desktop, then use anonymous authentication in Power BI Service, there is a similar thread for your reference.

https://community.powerbi.com/t5/Service/Refreshing-a-Restful-Data-Source-with-API-Key/td-p/131298

However, if it is not possible to access the root URL of your application anonymously, please set credential as suggested in the thread below.

https://community.powerbi.com/t5/Service/Web-Anonymous-refresh-failure-in-Power-bi-Service/td-p/4688...

Regards,
Lydia