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.
- Can't drop role because it has privileges that are not revoked even when REVOKE statement is successful
- How to transfer string from one column to another if it doesn’t contains substring
- How to use uuid with postgresql gist index type?
- How to format date if it can be null spring
- Postrgres Regex to replace part of a String
- Query Condition in Laravel 5
- How to restrict RLS on certain column(s) in PostgreSQL/Supabase?
- Joining too many tables makes Postgres query extremely slow
- Laravel and PHP8.3 can't connect to Postgres database
- CASE vs Multiple UPDATE queries for large data sets - Performance
- Invalid resource manager ID in primary checkpoint record
- postgresql list and order tables by size
- PgAdmin 4: Cannot edit rows from one table
- Add PRIMARY KEY constraint to existing table
- Count of available items with start and end dates grouped by month
- Hibernate mapping between Postgres array of varchar and a Java/Kotlin collection of enum
- Correct way to install psql without full Postgres on macOS?
- Why pg_typeof(TIMESTAMP '2004-10-19 10:23:54+02') shows timestamp without time zone
- "extra data after last expected column" while trying to import a csv file into postgresql
- Postgres - using select statement inside CASE WHEN
- How to split events into periods of activity in postgres?
- Streak for a given endDate SQL (Postgres)
- How to set a timestamptz column in postgres to a range of values to simulate real world data?
- Why is string literal '2021-02-16 09:00' without timezone information interpreted as `timestamp with time zone` with AT TIME ZONE?
- Postgres won't accept table alias before column name
- Named argument passed as a dict: SyntaxError: syntax error at or near "%" or SyntaxError: type modifiers must be simple constants or identifiers
- pg_cron - can not query cron.job after job is scheduled
- PostgreSQL Selecting Most Recent Entry for a Given ID
- Difference between timestamps with/without time zone in PostgreSQL
- connect superset to postgresql in a docker container - The port is closed