cant connect to datasource

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.

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.