View materialized views in Power BI?

[GWTF]

Hello to all!

Simple questions: are materialized views supported in Power BI?

I'm connected as the database owner and see al tables and views, but somehow I cannot see any materialized views...

Some information:

Database = PostgreSQL 15.1

PBI-client = 2.121.903.0 64-bit (september 2023)

Thanks!

[zenisekd · Accepted solution]

Hi, I believe you can, but you have to use native query. Follow this post:
https://stackoverflow.com/questions/76980158/power-bi-postgres-and-materialized-views

More on native query: https://learn.microsoft.com/en-us/power-query/native-database-query

Kudos (thumbs up) and mark as solution appreciated 🙂

[GWTF]

Hey, great!

Direct query works, altough it is not the most practical.

Thank you @Idrissshatila & @zenisekd !

[Idrissshatila · Accepted solution]

Hello @GWTF ,

true, you can see a meterialized view in pwoer bi, but you can select * from it, so you should write a query to retrieve the data in it.

[zenisekd · Accepted solution]

Hi, I believe you can, but you have to use native query. Follow this post:
https://stackoverflow.com/questions/76980158/power-bi-postgres-and-materialized-views

More on native query: https://learn.microsoft.com/en-us/power-query/native-database-query

Kudos (thumbs up) and mark as solution appreciated 🙂