cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

M.

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

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

@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

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.