Showing results for 
Search instead for 
Did you mean: 
marcin_wozniak Frequent Visitor
Frequent Visitor

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

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,


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


Moderator v-yuezhe-msft

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


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.

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


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.