Forum Discussion

sgargeta's avatar
sgargeta
New Member
9 years ago

Web.Contents is not working

Hi,

 

My report calls a webapi and authenticates using odata with bearer.

 

In the powerbi destop it works and the data is returned, but when it publishes in powerbi on the web I get the error.

 

Here part of the code that works on pbi desktop.

 

 

let
 url = "<URL>",
 GetJson = Web.Contents(url,
     [
         Headers = [#"uuid"="0",
		    #"modelo"="powerbi",
		    #"so"="powerbi",
	            #"versao"="powerbi",
		    #"tokenfirebase"="powerbi",
                    #"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"],
         RelativePath="/<partial url>/token",
         Content = Text.ToBinary("grant_type=password&username=USER&password=PASSWORD"),
         Timeout = #duration(0,0,5,0)
     ]
 ),
FormatAsJson = Json.Document(GetJson),
AccessToken = FormatAsJson[access_token],

 

In pbi online it generates the error

 

"Your data source can not be updated because the credentials are invalid. Please update your credentials and try again."

 

Authentication is anonymous.

 

I've tried all kinds of authentication none works

 

Please I need help

 

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi sgargeta,

     

    Is the web content public available? Maybe you can get it from your local network, while the Power BI Service can't get it from the public Internet. 

    Secondly, the authentication is anonymous, but you hardcode the username and password. Right? If it's possible using Power BI to do this. 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Thirdly, did you check the settings of dataset in the Power BI Servcie?

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    If it's possible for you to post the name of the API you are using, I could do some tests.

     

    Best regards!

    Dale