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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi eamonnde,

 

I'd like to suggest you double check dataset of reports, it seems like your credentials are dropped.

 

In addition, which gateway you used? If you mean personal gateway, have you try to use on-premise version and try again?

 

Regards,

Xiaoxin Sheng