Forum Discussion

r_beacroft's avatar
r_beacroft
Frequent Visitor
9 years ago
Solved

Power BI Desktop - Unable to pull from OData feed using Token authentication

Hi,

 

Am newbie to Power BI.

 

We have an OData feed that supports token authentication.

i.e. requests contain a header with "Authorization Token [guid]"

 

How can I configure Power BI to be able to call ourOData feed?

Is this possible?

 

Kind Regards,

Rik

6 Replies

  • r_beacroft's avatar
    r_beacroft
    Frequent Visitor
    9 years ago

    Hi,

     

    Am newbie to Power BI.

     

    We have an OData feed that supports token authentication.

    i.e. requests contain a header with "Authorization Token [guid]"

     

    How can I configure Power BI to be able to call ourOData feed?

    Is this possible?

     

    Kind Regards,

    Rik

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi r_beacroft,

      If you connect to OData feed using the following entry, and then enter your password, are you able to get desired result?


      If not, add a new blank query in Power BI Desktop, then paste one of the following codes in Advanced Editor and check if you get expected result.

      let 
Source = OData.Feed("URL", null, [Headers = [Authorization = "Bearer Your token" ] ])
in
Source

       

      let    
Source = Web.Contents("URL", [Headers=[#" Authorization  " = "Bearer Your token"]])
in
Source

       

      There are a similar thread and blog for your reference.
      http://stackoverflow.com/questions/33225590/authenticating-with-excel-power-query-against-net-odata-web-api
      http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/

       

      Thanks,
      Lydia Zhang

      • bavix's avatar
        bavix
        Frequent Visitor
        3 years ago

        In Power BI Desktop it works fine. But after publishing and trying to schedule automatic refresh I don't get a connection. Edit credentials

         

        What exactly do I have to provide in the credentials in Power BI Service?

        I tried several methods with/without "" but get "The credentials provided for the OData source are invalid"   

        Status code:400

         

        I used:

        Authentication method

        Key

         

        Account key

        Bearer ........

         

        Privacy level setting for this data source

        Organizational

         

        I also tried: 

        "Bearer ........."

         

        What do I wrong?