Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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 🙂
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.
Proud to be a Super User! | |
Hey, great!
Direct query works, altough it is not the most practical.
Thank you @Idrissshatila & @zenisekd !
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.
Proud to be a Super User! | |
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 🙂
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |