Forum Discussion

amitchandak's avatar
amitchandak
Super User
6 years ago

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

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    6 years ago

    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's avatar
      amitchandak
      Super User
      6 years ago

      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.