Getting native SQL queries for PostgreSQL without Power BI Desktop

[powerbi_dev]

Hi,

my team is baffled that we can't find a legitimate way to get native SQL queries for PostgreSQL without Power BI Desktop.

Why without Power BI Desktop? Because we create datasets programically right in the workspace and Power BI Desktop is restricted from using such datasets in edit mode.

• Gateway doesn't seem to log native SQL queries, only intermediate type queries and we think that it should have this feature
• Power BI Desktop doesn't work
• PostgreSQL doesn't support query history and other stuff

Did anyone else had this seemingly simple problem? What can be our options here?

[v-shex-msft · Accepted solution]

Hi @powerbi_dev,

I'd like to suggest you take look at the below link to know how to trace the queries on PostgreSQL side:

Is there a PostgreSQL equivalent of SQL Server profiler? - Stack Overflow

Regards,

Xiaoxin Sheng