SQL Statements for Postgres Database Connections (DirectQuery)

[schultzr]

I have been trying to query a table from a Postgres database using DirectQuery to gather multiple columns within a single function, however I am only able to pull one column per function. If I attempt to pull more than one column per function we get clickable error in each row stating "We don't support CLR type 'System.Object'".  Has anyone else had this issue?

[v-xinruzhu-msft · Accepted solution]

Hi,
Thanks for the solution @mh2587  provided, and i want to offer some more information for user to refer to.

hello, @schultzr , based on your description, as @mh2587  mentioned, you need to check if your data types are not support in power bi Desktop, you can refer to the following link about the support type in power bi desktop.

Data types in Power BI Desktop - Power BI | Microsoft Learn

If the information above cannot meet the requirement, you can refer to the following link.

c# - System.Object type which is not supported by PBI (Power BI)service - Stack Overflow

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mh2587]

Check your data types this might creating the issue

[schultzr]

I have verified data types and I can bring in any column, but only individually for some reason.