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)
RE: Materialized views in PostgreSQL
I am also really interested in this. It's perplexing that it's not supported out of the box
RE: Materialized views in PostgreSQL
com'on microsoft, its not that hard
RE: Materialized views in PostgreSQL
Really no reason to not have this...nor will it take much time to support...
RE: Materialized views in PostgreSQL
This is really not a "Needs Votes" issue. Materialized Views are a standard SQL database object and from a language standpoint are no different than any other object. By not supporting them, Power BI is forcing all the developers to break from standard practice to bend data models to work for Power BI.
RE: Materialized views in PostgreSQL
will this ever be implemented?
RE: Materialized views in PostgreSQL
So much disappoint!
RE: Materialized views in PostgreSQL
'You can access to a materialized view in PostGre by writing a request like that :
= public_Schema{[Name="XXXXX",Kind="View"]}[Data]
Tip: create first a new source and then just change the table name XXXXX
RE: Materialized views in PostgreSQL
Create your own normal view or just do the Advanced option in the Get Data and do a Select statement from the materialized view in there.
RE: Materialized views in PostgreSQL
Incredible that materialized views are not supported yet. Can this be fixed? I just upgraded PostgreSQL to be able use materialized views for performance reasons and PowerBI just killed it. OK, let's stay with workaround...
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.