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.

[ace4]

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

[mathieu_jehanno]

'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

[slado2008]

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.

[mike59]

So much disappoint!

[santosh_erukull]

will this ever be implemented?

[Steven_Kienle]

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.

[Qiyun_Feng]

Really no reason to not have this...nor will it take much time to support...

[kuhn]

com'on microsoft, its not that hard

[bobby3]

I am also really interested in this. It's perplexing that it's not supported out of the box

[fbcideas_migusr]

please help us! we need to be able to import materialized views