Forum Discussion
Postgresql Direct Query Fails on joined tables
I connected to Postgresql using direct Query. But when I try to get data it errors out. Using the latest version of NPGSQL 4.0.9 I have taken two tables in Direct query mode. Joined them on Key c...
Hi amitchandak ,
I'm a little confused about your scenario.
How do you connect with your data?
Use the built-in connector Postgresql Database or the Power Query?
In addition, you could refer to this thread which may be helpful.
Best Regards,
Cherry
In the Model view, I have joined Table1 to table2. Table 1 is Carrier_invoice having id and Table2 Shipment_invoice_details having Invoice_header_id. Power Bi was able to find 1-Many realtion. These tables are big, so I can not move data inside Power BI and Power BI now supporting the Direct query on PostgreSQL, so trying that. In the past, I was able to use the same data in Power BI using load data option.
I have a requirement for some live reports.