Problem with the credentials

miriambb , In Home Tab -> Data Transformation -> Datasource setting

 

Clear permissions and try again

Hi miriambb ,

Power Bi has a two hour window to refresh the data. If it is taking less than 2 hours to throw the timeout let's try something.

There is no documentation about the "options" parameters for redshift, but it says you can add options parameters. 

https://www.powerquery.io/accessing-data/amazon-redshift/amazonredshift.database

Let's try adding a commandTimeout like in SQL Server 

https://docs.microsoft.com/en-us/powerquery-m/sql-database

The idea would be getting in Power Bi Desktop, Transform Data, Source step. Check that Power query code and add a parameter before the last ")" like  

AmazonRedshift.Database(ServerName, DatabaseName, [CommandTimeout=#duration(0, 1, 0, 0)])

That will use 1 hour window to resolve the query. By default power query set up at 10 or 15 minutes.

 

And similar error refer:

https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-troubleshooting-power-bi-dataset-refresh-failures/ba-p/3261466 

https://stackoverflow.com/questions/16459990/sql-error-0-sqlstate-08s01-communications-link-failure 

https://community.powerbi.com/t5/Report-Server/Troubleshoot-quot-Error-returned-Dat-ERROR-08S01-error-00000005/m-p/2548351 

https://community.powerbi.com/t5/Desktop/Amazon-Redshift-ODBC-Error-while-connecting-to-Incora/m-p/647513 

 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien