Redshift with Power Query

[Anonymous]

I have set up a Power Query connection with Redshift, however once I upload it to the service I get the following errors. My credentials are correct and I've reentered them several times to the semantic model to no avail. I do not need a Gateway since it's a Redshift connection so I shouldn't have to set one up. I've googled this and can't seem to find the fix. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

In Power Query Desktop, go to File > Options and Settings > Data Source Settings. Under Global permissions, select any old Amazon Redshift data source connections and click on Clear Permission. Then reconnect to your Redshift database and try it again.

Mazon Redshift has a per-user connection limit. Ensure that you do not have this limit. Also you can check if there are any locks or active transactions on the data source side. Maybe this two documents can help you: Power Query Amazon Redshift connector - Power Query | Microsoft Learn and Solved: redshift Connection (Fatal Error: Too many connect... - Power Platform Community (microsoft.com)

You also need to specify advanced options such as the server port.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .