Materialized views in PostgreSQL

[hela2]

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.

[Cobra]

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

[philipp_leufke]

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

[brains]

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

[brains]

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 ?

[2014069610]

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.

[nmsivasankar]

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 ?

[rklaehn]

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

[dereka1]

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

[kanthimathicse]

'+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

[sunder-nagaraja]

A nice workaround is to create a view in PostgreSQL for the materialized view. Worked wonders. Indexed views in SQL server do not allow for remote access. Hopefully SQL server 2016 may have those features available.