Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @cbtekrony ,
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....
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.
Hi @cbtekrony ,
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....
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.
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 .