How to Connect PowerBI to a local and cloud-hosted postgreSQL database

PowerBI is a business analytics platform developed and maintained by Microsoft. It has gained traction for its simplicity and has increasingly become the go to software for business analytics by many small, medium and large businesses. Many, if not most, of these businesses have their data stored in databases because databases ensure the data is secure, has structure and can be stored and retrieved at anytime. Analytics platforms like powerBI therefore have to provide means through which analysts can access the company data that is housed in the databases. Connecting PowerBI to a local postgres database The following steps outline how to connect PowerBI to a local postgres database: Launch PowerBI on your computer. Create a Blank report and from the Home tab click on 'Get Data'. Click on More... option on the Common Data Sources Wizard that appears On the Get Data wizard box scroll down and locate PostgreSQL database option and select it. Click on the green Connect button at the bottom