Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have two servers. They are deployed with ansible scripts, with an identical schema, identical postgresql user.
The only difference is that one is an older VM and uses postgresql v10 (a docker container) and one has the postgresql v12 docker container.
The schema has a carefully constructed set of foreign key relationships to help with automatic detection of relationships.
On connection and import to Power BI desktop, the data stored on the v10 postgres works wonderfully well: all table relationships are detected. On the v12 database, no relationships are detected. This happens regardless of import or Direct Query.
The schema is managed by django's ORM, which means the foreign key column names have _id suffixed at the end, so the foreign key columns don't have the same name as the unique column in the parent table.
Example: on the order header, we have order_guid as the unique column. The foreign key is order_guid_id
This can not easily by changed. It shouldn't matter, because the foreign keys are defined. It seems that there is a bug with the postgresql driver in Power BI desktop. I can revert to postgresql v10, so it's not the end of the world.
This is version info for Power BI Desktop
Version: 2.90.782.0 64-bit (February 2021)
This is power bi desktop
Update: it is a permission issue, I was wrong about the postgresql version. The user (role) I have created for access needs to have superuser permission before related tables are recognised. Initially I gave the user select access to all tables, and ALL privs on the public schema, and even ALL privs on the database. But only when I added superuser to the role were related tables recognised. This seeems crazy.
Hi @timatgca
Did you use import connection to get data from postgresql?
You can try postgresql connection or ODBC to get data from postgresql.
For Reference: PostgreSQL To Power BI: 3 Best Ways To Connect
What does the role mean, roles in RLS or other?
Could you share a screenshot of your issue to me?
And you can show me the result you want.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |