Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi.
I made connection postgresql DB on power bi desktop, and i can see the table(DB data)
but when i upload the pbix file to power bi service,
'An error happened while reading data from the provider: 'No connection could be made because the target machine actively refused it'
i can't understand why it couldn't be connected.. it was possible to connect through power bi desktop to postgresql DB!
i wonder how to connect and what is the solution 😞 ...?
(DB ID, PASSWORD is correct !! :(.. )
Hi @ryankang
You would need to have a gateway to connect to the PostgreSQL database
You could follow these steps which are similar to get it connected to the database: Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Docs
thank you for reply.
but i can't resolve this problem, and i don't understand why i have to make a gateway through the site you
mentioned?
and i can see the table in the desktop, and there is no problem.
but when i upload the file to the service, this error comes up!
please let me know the detail.. 😞
Hi @ryankang ,
Have you solved your question?
The reason why installing gateway is that may be your data source is on-premise, if it is from local, the gateway will be necessary.
If you still in trouble, can you give me a screenshot about your error message? Thank you in advance~
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly