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

eamonnde's avatar
eamonnde
Frequent Visitor
8 years ago

Hi Xiaoxin,

 

The data is being directly imported from a SQL Server DB with a SQL query being used to import the data directly into Power BI.

 

The credentials give me permission to pull the data into Power BI without any issues and the refresh option in Power BI desktop works fine, the same credentials are used in Power BI online to access the data through the gateway, all gateway connections are online and good to go.

 

When i hit refresh on report 1 in Power BI online, all content refreshes without any issues, when i do the same for report 2 I get the following response.

 

 

Thanks

Eamonn

ttankka's avatar
ttankka
Frequent Visitor
8 years ago

Eamon,

 

I am currently having the same issue that you describe.  Were you able to resolve this?  If so, could you please share.

 

Thank you,

 

Tim

  • eamonnde's avatar
    eamonnde
    Frequent Visitor
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      That's not a solution

    • WinsonW's avatar
      WinsonW
      New Member
      7 years ago

      I am having the same issue but I am not able to follow your answer. Can you please elaborate little bit how/where I need to add the certificate? 

      Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      How and where can I add the certificate? I'm having the same issue, the report worked perfectly for months and suddenly I have this problem, I have no idea if something happened with the domain accounts or what. Please show us how you solved this issue.