How to Connect Power BI to PostgreSQL Database using Pagila Database

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

[@lucianlackman8103]

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

[@IAMSOMEBI]

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

[@ahmedhelal920]

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 ! 😀

[@olayinkao.3466]

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?

[@TheOyinbooke]

Thanks for your feedback Olayinka. I will work on this video

[@MultiPrashantmishra]

Thanks for explaining in good manner.

[@ayoolaaguda]

Thank you very much. This was helpful

[@hello-u2w]

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

[@datawhipper]

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

[@igbegrowth4442]

This was helpful,thanks.

[@krispinatitis6986]

thx you for your video

[@TheOyinbooke]

You're welcome

[@andreforttuna]

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

[@congminhle3345]

Thank you a lot! Really helpful!

[@shubh13272anand]

Thanks a lot

[@TheOyinbooke]

Most welcome

[@willywales9446]

Thank you Sir

[@TheOyinbooke]

Most welcome

[@tonykuiper9127]

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...

[@tonykuiper9127]

@Saidh Fabis M I worked around the issue eventually. I installed the postgresql driver in windows and use odbc to connect. It doesn't explain why the native Microsoft connector in a Microsoft application won't connect to a Microsoft data source (postgresql on Azure).

[@ylchanivy]

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!

[@petrabasic5612]

hello, instead of just ''localhost'', for Server I used ''localhost: '' and that way I didn't have to enter the password

[@rockey3863]

Can we connect postgres in powerbi via WEB?

[@TheOyinbooke]

Yes. Bur you must have the database on cloud and have the login details to the online server

[@rockeykotwal]

How can I get ip of power bi so that I can whitelist it to have access to my db

[@khushivyas970]

How to check database password I forgot it

[@ianbrussolo7623]

thank you!!!!

[@eduoliveira6958]

You Rock! thankss!!