cant connect to datasource

[SokuTaIke]

Hi, I'm the Power BI admin of a large organization.

We have a report connected to a database via direct query that can't connect to the database once published. This is the summarization of the situation:

• the datagateway is connected and working
• the account registered in the datagateway has read permissions on the database
• other reports using the same database and the same credentials have no issues
• the datasource name in the error is unfamiliar with us and we can't find it
• the error specifies "there is a time-out in the connection or the credentials are invalid"
• the report uses a native (SQL) database query instead of power query - can this be the problem?

[v-binbinyu-msft · Accepted solution]

Hi @SokuTaIke ,

The error message "There is a time-out in the connection or the credentials are invalid" in Power BI usually indicates an issue with the connection or the credentials used for authentication. Here are a few possible reasons and solutions to consider:

1. Connection Time-out: If the error is due to a time-out, you can try increasing the timeout value in your Power BI settings or optimizing your data source to improve performance.

2. Invalid Credentials: Ensure that the credentials used for authentication are correct and up-to-date. Double-check the username, password, and any other required authentication details.

3. Network or Firewall Issues: Check if there are any network or firewall restrictions preventing a successful connection. Consult with your network administrator to ensure that the necessary ports and protocols are open.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SokuTaIke · Accepted solution]

We solved the problem:

Usually our accounts work when they have read permission on database level. SERVER/DATABASE

However, in this specific case read permissions were needed on schema level SERVER/DATABASE/SCHEMA

This might have to do with extra tight security measures for this specific schema in the SQL database, but we are not sure. 

[v-binbinyu-msft · Accepted solution]

Hi @SokuTaIke ,

The error message "There is a time-out in the connection or the credentials are invalid" in Power BI usually indicates an issue with the connection or the credentials used for authentication. Here are a few possible reasons and solutions to consider:

1. Connection Time-out: If the error is due to a time-out, you can try increasing the timeout value in your Power BI settings or optimizing your data source to improve performance.

2. Invalid Credentials: Ensure that the credentials used for authentication are correct and up-to-date. Double-check the username, password, and any other required authentication details.

3. Network or Firewall Issues: Check if there are any network or firewall restrictions preventing a successful connection. Consult with your network administrator to ensure that the necessary ports and protocols are open.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ribisht17]

@SokuTaIke 

Please check

Troubleshoot gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users