Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
johnpjustus
Helper III
Helper III

Power BI Service Logs

Hi.

Where all the PowerBI service logs are stored?

Eg., SQL query behind the datamodel when the report runs?

User Audit logs.

Event logs

Performance logs

Any other logs.

Thanks,

John

2 REPLIES 2
johnpjustus
Helper III
Helper III

Thank you so much for the information.

v-yueyunzh-msft
Community Support
Community Support

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

 

(4)Performance logs:

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! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors