Forum Discussion
PBI Web Service Refresh with Access Token to GitHub?
- 1 year ago
Hi SeanBI,
Thank you for reaching out to Microsoft Fabric Community.
The issue here is because of the power bi service security model. Power bi service does not support using custom Authorization headers in Web.Contents() unless the authentication method is set to Anonymous and the data source is marked as anonymous in the data source settings in the service.
The GitHub API is being accessed using a PAT in the authorization header, this works fine in desktop but the service blocks it unless everything is configured for anonymous access and it will not work if a gateway is involved or if other authentication methods like OAuth or Basic are used.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi, SeanBI
I think Chris Webb's BI Blog will help you solve this problem:
Chris Webb's BI Blog: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI