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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
81 | |
79 | |
67 |
User | Count |
---|---|
122 | |
110 | |
94 | |
82 | |
77 |