Forum Discussion

nmsivasankar's avatar
nmsivasankar
Advocate II
7 years ago

Power BI support for materialized view built on PostgreSQL

Power BI support for materialized view built on PostgreSQL-  Currently Power BI does not list the Materialized views created on the postgress DB, it shows only the tables and views. Microsoft has any plan to support the MV feature of PostgreSQL in the future release and when this enhancement is made available? We have plenty of materialized views created on the postrges, due to the limitation with Power BI, we are living with creating views from the MV as a workaround. I am not sure why this has not supported ?

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi nmsivasankar



    Microsoft has any plan to support the MV feature of PostgreSQL in the future release and when this enhancement is made available? We have plenty of materialized views created on the postrges, due to the limitation with Power BI, we are living with creating views from the MV as a workaround. I am not sure why this has not supported ?



    I'm not clear if Microsoft have the plan to support the MV feature of PostgreSQL in the future release.

     

    However, you could vote this similar idea in here which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.

     

    Best Regards,

    Cherry

    • nmsivasankar's avatar
      nmsivasankar
      Advocate II

      Hi Cherry,

       

      Thanks very much for your reply. I have voted for the MV feature, not sure when Microsoft will action this request ..

       

      Regards

      Siva