Forum Discussion
cant connect to datasource
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?
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.
3 Replies
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=mGnNn6gnrKkRegards,
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 UsersHi 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.
