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?
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.