Forum Discussion

tcouey's avatar
tcouey
Frequent Visitor
2 years ago
Solved

Getting web data via api and authorization token

Hi   I am using an api authorization token generated from one of our vendor websites. I then use an api endpoint, and the authorization header/token to pull our data from the vendor into powerbi de...
Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi tcouey ,

     

    Powerbi supports setting the format of its request headers when connecting to a web data source.
    If you need to provide an API authorization token when connecting to a web data source, you can add the header in the advance option.
    The Bearer your_api_token_here section is the value of the Authorization header, where Bearer is a common authentication scheme followed by the actual API token.

     

    For more details, you can refer to below document:

    Connect to a webpage from Power BI Desktop - Power BI | Microsoft Learn

    Power Query Web connector - Power Query | Microsoft Learn

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

BenoitB's avatar
BenoitB
New Member
1 year ago

Hi
I also want to use Token Authentication for a semantic model in Power BI Service. 
Creating it with Power BI Desktop is OK as said Anonymous, I used the Authorization header.

But when publishing it on my workspace in app.powerbi.com, I can't use Gateway Datasource to schedule refresh because it seems that On-premise Gateway Datasource Web only supports Anonymous or Basic Auth ?
Is there any workaround ?
Best regards,
BenoitB