Postgresql Direct Query Fails on joined tables

[amitchandak]

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 column.

And then try to run a query where view by/group by is from the first table and agg column from the second tables.

[amitchandak]

I have taken two tables in Direct query mode.

Joined them on Key column.

And then try to run a query where view by/group by is from the first table and agg column from the second tables.

[v-piga-msft]

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

[amitchandak]

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.