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 (20)
RE: Materialized views in PostgreSQL
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.
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
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.
RE: Materialized views in PostgreSQL
I would also find this very useful. Don't see what's the problem with implementing this.
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.
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 ?
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 ?
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
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...
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