Forum Discussion

eamonnde's avatar
eamonnde
Frequent Visitor
8 years ago
Solved

Invalid connection credentials Refresh issue

Hi,   I've created two reports in power bi and published them to power bi online. I've also created an on premise data gateway on a device that is constantly running and added the corresponding gat...
Need Help
  • eamonnde's avatar
    eamonnde
    7 years ago

    Hi Tim,

     

    Our issue seemed to revolve around the certificate not have the server name, we added it and it worked for us.

     

    Apologies for the delay in response.

    Eamonn

eaglewoods's avatar
eaglewoods
Frequent Visitor
4 years ago

Dear all,

 

Not sure, after so long if anyone has found the solution to this issue, but I was facing the same issue while refreshing PBI web services with an API token.

As nobody mentioned the solution in this thread, I am including how i solved this issue.

1) In PBI Desktop, I gave the API with the permanent token in the Advanced Editor. 

2) In PBI webservices, I used this below settings.

And this worked for me. The PBI webservices are now refreshing on demand and I can also schedule 8 refresh /day. PBI Pro user.

 

Cheers!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    interesting.  These are exactly the same steps I'm following but my issue is not resolved.  may I ask if your url string contains any additional parameters?  ex: http://rest?param1=x&param2=z.

    My connection string within desktop is as follows: 

    Source = Json.Document(Web.Contents("https://xxx.yyy.com/api/xxx/yyy" & "?param1=false&param2=true&param3=true", [Headers=[#"my-api-key"="abcdefgkey1234"]]))

     

    thank you,

     

  • florianh's avatar
    florianh
    Frequent Visitor
    1 year ago

    that worked for me as well!