Forum Discussion
Solved
View materialized views in Power BI?
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....
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 🙂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.
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.