How to display SQL in PowerBI WebApp

[powerbisos]

Hi all,

is there a way to show the SQL-queries done by the PowerBI WebApp (not "Desktop") when generating reports?
Thanks in advance!

David

[GilbertQ]

Hi @powerbisos 

Is this when using the Import mode?

If so you can use the API Scanner to get all the data which will have the code in there.

Here is my blog post on how to get this data: Getting the lineage from a Power BI dataset to table to data source to original query - FourMoo | Po...

If it is DirectQuery you will need to capture this on the underlying database system.

[powerbisos]

Hi GilbertQ,

thanks for your answer!

Iam using the on-premises data gateway with scheduled refresh with MariaDB as data source, so on the MariaDB-side i can only see the queries fetching all data for syncing them into "something" PowerBI can access (i dont know anything about PowerBI internals), but i dont see the specific queries of the reports since they are not done on the original MariaDB source db.

I have not created that existing reports .. but maybe i can switch them somehow to use MariaDB directly via the on-premises data gateway to see the queries on MariaDB? i have not figured out yet how to change that reports to DirectQuery. The most promising place to change that is in the screenshot below (some private details removed, the data sync is working correctly for that datasource. that tooltip "Manage Connections and Gateways" does not allow change to DirectQuery):

thanks in advance,

David