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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
