cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbisos
New Member

How to display SQL in PowerBI WebApp

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

2 REPLIES 2
GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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):

Bildschirmfoto von 2023-03-24 11-37-23.png

 

thanks in advance,

David

 

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors