How to Connect Power BI to PostgreSQL Database using Pagila Database

preview_player
Показать описание
It is time to connect Power BI to the Pagila database we restored in the last video.
This is a continuation of the data analysis series for beginners - PostgreSQL Track. We will be working with PostgreSQL Database and building a BI project from this.

First, what is a database?
A database can easily be described as a collection of information that is structured in such a way that it is easy to manage and update.

We have several database servers which include MS SQL Server, MySQL Server, MongoDB, PostgreSQL, etc...

#sql #database #postgresql
Рекомендации по теме
Комментарии
Автор

Looked for this video everywhere nobody could even do a video only you. Thank you very much, life saver

lucianlackman
Автор

Oh! Omo... You're a life saver Sir! Thank you for this video...

IAMSOMEBI
Автор

thanks for your great video actually i am professional on using power bi and DAX and learned SQL for data analysis, but what i was searching about how to connect database to power bi and here i found what i need ! 😀

ahmedhelal
Автор

Hi Oyinbooke, this was really helpful and very easy to understand! You are definitely a good teacher! Can you kindly do a video on how to connect PowerBI to Oracle Database?

olayinkao.
Автор

Thanks Oyinbooke. I am experiencing issues with a gateway connection for postgresql

datawhipper
Автор

what do you do when you get this error: 'The remote certificate is invalid according to the validation procedure.'"

hello-uw
Автор

The problem is that later in the power bi service, the scheduling will not work.

andreforttuna
Автор

I am trying to connect to postgresql on Azure... I keep getting a certificate error. Do you know how to fix? Do you know what drivers I should have on my machine also? I think I have installed everything I have to and can see the databases in pg4admin, but power bi wont connect...

tonykuiper
Автор

How to check database password I forgot it

khushivyas
Автор

Hi, thank you for this post. I'm trying to connect postgres sql to power BI, tried the above steps but is unsure if the password required is the postres sql password? i entered my postgre password but it does work. Can anyone help me on this? many thanks!

ylchanivy
Автор

Can we connect postgres in powerbi via WEB?

rockey