Forum Discussion
Issues with connection whith powerbi and postgresql
I´m trying publish my dashboard on powebi web, but i have some troubles with my credentials.
I have IP, schema, user, password from the database that i use, but when i try input this on powerbi app web, e always have error of connection.
Sorry for my english guys. But i wish yours understand.
3 Replies
Hi IagoOliveira
You will need to install the On-Premise Gateway and use that to connect to your database server from the Power BI Service?
Here is how to install the On-Premise Gateway.
Install an on-premises data gateway | Microsoft Learn
Add or remove a gateway data source - Power BI | Microsoft Learn
Dear GilbertQ,
Its working, thanks for help, but i had install on my pc the odbc data source, to keep the connection UP. Now i have another guest.
There is someone type of configuration, that i can use to uso a diferent way to connect, but this time using import method rather than powerquerry?
Because when i use import method i can´t schedule automatics updates in powerbi.app.
Hi IagoOliveira
Once you have installed the Gateway, you then need to configure the data source in the Power BI Service.
Add or remove a gateway data source - Power BI | Microsoft Learn
Then upload your PBIX and configure it to use the data source.
Manage your data source - import and scheduled refresh - Power BI | Microsoft Learn
