Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We are using Query Editor to write a query to fetch data from vendor using REST API call. On refresh, when the query executes, it gets stuck in infinite execution. The same REST API call works with postman. We need to analyse this issue with Power BI logs. We followed the link to enable tracing but were not able to get the logs related to the Query execution. Could you please help us to find those logs?
Hi @Dhyey29 ,
A PowerShell sample is available to help you learn how to filter and retrieve Power BI activity log events. All code fragments and scenarios are annotated with how-to instructions and common gaps or issues to watch out for. Two scenarios are covered:
You must meet the following requirements:
More details: Access the Power BI activity log - Power BI | Microsoft Docs
I have also found a similar post, please refer to it to see if it helps you.
Solved: power bi log files - Microsoft Power BI Community
you could go to File—>Option and Settings—>Options—>Diagnostics—>tick the Enable tracing —> Open traces folder, then you will find the Power BI log files.
If it still does not help, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous,
We tried looking at the diagnostic logs generated by Query Diagnostics - https://docs.microsoft.com/en-us/power-query/querydiagnostics, but we are only able to get the URL and Request query. Is there any way we can get the actual response obtained from the API call, so we can use it to debug our issue?
Hi @Dhyey29 ,
Here is a blog about how to Export activity logs.
How to view the frequency of user usage for all wo... - Microsoft Power BI Community
Hope it would help you.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous,
We tried looking into the Audit logs and the Power BI Activity logs as well, but we only get the logs related to user activities performed on the Power BI Service platform. We are looking for logs regarding the API calls made through the Power BI query specifically - the request, response body, and status codes which would help us in troubleshooting any issues with the API calls.
The API calls with be an Azure admin event. Not in the power bi user event logs. You still wont get the full detail I believe though. That would require you to use like postman to test before hand.
User | Count |
---|---|
77 | |
76 | |
42 | |
30 | |
24 |
User | Count |
---|---|
97 | |
91 | |
52 | |
47 | |
46 |