Getting native SQL queries for PostgreSQL without Power BI Desktop

Anonymous — Mon, 05 Dec 2022 09:26:27 GMT

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?

Re: Getting native SQL queries for PostgreSQL without Power BI Desktop

Anonymous — Tue, 06 Dec 2022 02:38:46 GMT

Hi @Anonymous,

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

topic Getting native SQL queries for PostgreSQL without Power BI Desktop in Developer

Getting native SQL queries for PostgreSQL without Power BI Desktop

Re: Getting native SQL queries for PostgreSQL without Power BI Desktop