Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Redshift with Power Query

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. 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies