Power BI

Needs Votes

Materialized views in PostgreSQL

Vote (136)

Helge Larsen on 02 Feb 2017 22:54:03

When I connect Power Query to a PostgreSQL database I get a list of tables and views in the database. But materialized views are not shown. I would suggest that Power Query would be able to connect to materialized views, too.

Comments (19)

Comments (19)

kanthi on 05 Jul 2020 23:35:57

RE: Materialized views in PostgreSQL

'+1. We are currently handling millions of records which views cannot be used and we thought of using materialized view. Please bring this basic feature

Anderson on 05 Jul 2020 23:34:28

RE: Materialized views in PostgreSQL

'+1 We just purchased PowerBI for connecting to PostgreSQL. Material views are a solid requirement for us. I am questioning the decision if its apparently that hard to get what we need especially since material views are not that much different as a consumer of data.

Rüdiger Klaehn on 05 Jul 2020 23:33:37

RE: Materialized views in PostgreSQL

I would also find this very useful. Don't see what's the problem with implementing this.

Kyle on 05 Jul 2020 23:30:37

RE: Materialized views in PostgreSQL

Up for this, very helpful in reporting where you can just refresh the data via a Materialized View instead of creating multiple tables, which is considered to be a bad practice in the principles of data warehouse.

Sivasankar on 05 Jul 2020 23:30:28

RE: Materialized views in PostgreSQL

We are in a similar situation where we have materialised view built on PostgreSQL but Power BI was not able to use due to the limitation of Power BI

Microsoft has any plan to support the MV feature of PostgreSQL in the future release ?

Sanj on 05 Jul 2020 23:27:19

RE: Materialized views in PostgreSQL

MV is a reporting object and if this is not supported then it would lead us to use other reporting tools that do support . So how about some comment from the PowerBI team? as per below ?

Sanj on 05 Jul 2020 23:27:17

RE: Materialized views in PostgreSQL

Hello anyone out there. Any idea 1. IF and 2. When this feature that support PostgreSQL Materialsed View be available. Postgres is now at version 9.6 x ?

Thanks

Power BI User on 05 Jul 2020 23:18:22

RE: Materialized views in PostgreSQL

To be honest, I can hardly understand how this elementary feature has stayed unresolved for more than a year now. Especially as it seems rather simple to fix.

I am currently evaluating PowerBI vs. Tableau and this might become the tipping scale...

Koen on 05 Jul 2020 23:03:08

RE: Materialized views in PostgreSQL

Same issue here. Easy but not so great work around: create another nrmal view with select * from the materialized view