Problem with the credentials

[miriambb]

Hi everyone,

I was working normally on creating the dashboard yesterday and today I am getting an error in the Powerbi Server. I already tried to reset the credentials but nothing happened... could someone advise?

thank you

Miriam

[v-luwang-msft]

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-b... 

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-erro... 

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

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

Best Regards

Lucien

[amitchandak]

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

Clear permissions and try again

[miriambb]

Hi @amitchandak,

I tried that, but nothing happened when I clicked on Clear permissions... those are not disapearing 

Does it ever happen to you?

Thank you

Miriam