Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |