Skip to main content

    Power BI

    New

    Materialized views in PostgreSQL

    Vote (57) Share
    Helge Larsen's profile image

    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 (13)
    Helge Larsen's profile image Profile Picture

    5897ee16 28a1-4f37-927e-2af255113a6e 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

    Helge Larsen's profile image Profile Picture

    cfda4434 81f4-4e74-bc22-e976ecb25128 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...

    Helge Larsen's profile image Profile Picture

    820f812f 81c7-43f0-a046-1a2d31de4e8a 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