Power BI, Postgres, and materialized views
I've created a materialized view in Postgres. I can see the new table and the data using DBeaver. It resides in the same schema as my other tables.
For the life of me, I can't figure out how to get the mv to appear in Power BI. When I create a new source it only shows me tables.
Any suggestions are appreciated.
In Power Query, I have performed a Refresh All and I've tried to reconfigure the Navigation step. No success.
Solution
You can use a Native SQL Query in the Postgres Connector, eg select * from Labors_mv.
- How to return JSON objects without explicit aliasing in postgresql
- Postgresql + psycopg: Bulk Insert large data with POSTGRESQL function call
- Better way to insert a very large data into PostgreSQL tables
- Cannot drop PostgreSQL role. Error: `cannot be dropped because some objects depend on it`
- pgadmin4 : postgresql application server could not be contacted
- How can I specify the migrations directory for typeorm CLI?
- SQL full outer join, default value to column in other table
- PostgreSQL database not connecting to spring-boot application
- Setting auto increment id in Postgres with Navicat
- Dropping all views in postgreSql
- Where does PostgreSQL store configuration/conf files?
- Query produces "function unnest(unknown) is not unique error", but is executed fine by the application
- SQL statement evaluation order
- Execute multiple queries as one dblink transaction
- Spring Data R2DBC PostgreSQL not saving new record with UUID @Id
- PostgreSQL Stack Builder Installation Certificate verification problem on Windows
- How do you connect to postgres running in a Docker container on OSx?
- Order by the oldest relation Postgres
- How to create a role in postgress db which supports the CRUD operations but doesn't allow to drop the database and tables with that role
- Error calling procedure in posgres "No procedure matches the given name and argument types. You might need to add explicit type casts."
- How To Import a Big .csv(~2GB) Into a PostgreSQL Table
- Rails trying to connect to postgresql on port 5432, but it's configured for 5433
- Power BI, Postgres, and materialized views
- How do you name the PostgreSQL indexes when using Haystack's PgvectorDocumentStore?
- Postgresql showing only one decimal, Grafana showing 2
- Django Postgresql ORM optimisation
- "could not identify an equality operator for type json" when using distinct
- Syntax error at end of input in PostgreSQL
- How to increase the connection limit for the Google Cloud SQL Postgres database?
- postgresql timestamptz conversion to localtime issue