March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
37 | |
32 | |
20 | |
11 | |
8 |
User | Count |
---|---|
52 | |
42 | |
28 | |
12 | |
11 |