Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.