ODBC navigator doesn't show materialized views

[Anonymous]

I'm trying to pull data into Power BI using an ODBC connection to a Postgres database. When I select my ODBC connection to connect to, the Navigator pops up for me to select tables to load. The list of tables include all the tables and views in my database, but it doesn't include Materialized Views. 

Is there any way to get Materialized Views into Power BI?

[v-caliao-msft · Accepted solution]

@Anonymous,

Based on my research, Power BI is not support Materialized Views currently. Some on had already posted this feature reuqest, pelase refer to the link below to see the details.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17924470-materialized-views-in-postgresql

Thank you for your understanding.

Regards,

Charlie Liao

[grant_ar]

@v-caliao-msftAlthough you are correct that PowerBI does not natively support Materlized views you can edit or create new PowerQueries which will allow you to access the data via the Materlized view.

To do this access the PowerQuery edititor by editing your existing queries and then go to a query you wish to modify to access a Materilized view. You can then "right click" and access the advanced editor where you can then edit the query directly.

See an example below which i modified which is pulling data from a schema reporting which only contains materlized views. I then leave the Kind type on the component import as "Table" and this will allow PoweBI to pull in the data from the Materlized view and treat it like a normal table.

let
Source = Odbc.DataSource("dsn=demoserver", [HierarchicalNavigation=true]),
bds_hub_report_Database = Source{[Name="bds_hub",Kind="Database"]}[Data],
public_Schema = bds_hub_report_Database{[Name="reporting",Kind="Schema"]}[Data],
component_Table = public_Schema{[Name="component",Kind="Table"]}[Data]
in
component_Table

There maybe some limitations to this approach and it will not fix the auto import capability within PoweBI but at least it gives you a method of pulling in your data.