Hi , @johnpjustus
According to your description, you want to know about the "Power BI Service Logs".
This is my undertand for your question:
(1)Where all the PowerBI service logs are stored?
The Power BI Services logs are both stored in the cloud database , you can search and check them in some place.
(2)SQL query behind the datamodel when the report runs?
When you load a report, If you are importing mode, then your data is stored in the cloud, and when you load data, the query is sent directly to the data in the cloud. Queries are sent to your data source only when you need to refresh.
If you are in Direct Query or Live Connection mode, the query will be sent directly to your data source.
If your data source is SQL Server, you can catch the sent SQL query in SQL Profiler.
(3)User Audit Logs and Even Log (Activity Log in Power Bi Service):
You can obtain the corresponding log information according to the following documents:
Track user activities in Power BI - Power BI | Microsoft Learn
The Performance logs in Power BI service is related to the premium capacity , this is for the capacity's admin to manage the capacity performance .
For more information, you can refer to :
Monitor Power BI Premium capacities with the Premium metrics app. - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly