Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @amitchandak ,
In my sample, it worked fine. I think the scenario may be caused when you merge queries. Can you please share some screenshots about the step of merging queries and the results? You could mask the sensitive data.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I added tables and joined them. And they trying to get data. Till the time I get data from one table, it is working. But if I use two tables, it is not working.
@ImkeF, Please suggest.
Anyway to resolve this
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |