Forum Discussion

boboost's avatar
boboost
Regular Visitor
5 years ago
Solved

Problem when publishing API connection (desktop works fine)

Hi, I setup a connection with an API in Power BI desktop. This works fine, except when I publish it says that my datasource cannot be refreshed because my credentials are not correct. I think it has...
Need Help
  • boboost's avatar
    boboost
    5 years ago

    Hi thanks, I solved it by clearing the cache in the desktop version, setting the datasource to anonymous en public. I also had to set it to public on the cloud version. then it worked eventually.

boboost's avatar
boboost
Regular Visitor
5 years ago

hi, here is the message:

 

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, boboost 

 

The credential information seems to be incomplete.

 

Best Regards

Janey Guo

 

  • boboost's avatar
    boboost
    Regular Visitor
    5 years ago

    Hi thanks, I solved it by clearing the cache in the desktop version, setting the datasource to anonymous en public. I also had to set it to public on the cloud version. then it worked eventually.

  • boboost's avatar
    boboost
    Regular Visitor
    5 years ago

    Hi,

     

    I know, here when i enter the credentials:

     

    this is a test site for my api, see that i need to enter THREE things: username password AND databasename:

    In the code I already entered the BASIC Authenication string, (so i don't understand why I even should enter credentials.)

     

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    boboost  Is the user name and password you entered from a computer or a database?

  • boboost's avatar
    boboost
    Regular Visitor
    5 years ago

    they are from the database, (the API needs them)