Chapter 4 Power BI on Open Source Stack

PostgreSQL is an open source object-relational database management system (ORDBMS). It is based on POSTGRES, which was introduced at Berkeley Computer Science Department at the University of California. The idea behind using the name PostgreSQL was to highlight the relationship between POSTGRES and SQL. This means that a large set of SQL standards are supported by PostgreSQL. In addition, PostgreSQL also supports:

–Triggers

–Views

–Complicated queries

–Foreign keys

–Transactional integrity

–Concurrency control

This chapter provides a step-by-step guide to integrating Power BI with PostgreSQL and creating reports in Power BI through the PostgreSQL database.

Integrating PostgreSQL with Power BI

As discussed ...

Get Power BI Data Analysis and Visualization now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.