Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

nimishnagpal13

Unable to trace back PowerBi Activity (ViewReport) to the GatewayLogs

Submitted by on ‎08-06-2021 06:23 AM

Hello Team,

 

I am working on tracking the activities on the PowerBI service like Viewing the report to the queries that the report triggered on the gateway. 

To start with, I used the Admin REST API to get the activity for the specific time and user. I found the 'View Activity' on the report, I visited in that timeframe. The API call returns a lot of information about the report, workspace, requestID, etc.

 

Thereafter in looked into the GatewayLogs for QueryExecutionReport/QueryStatReport. I could identify the query that came from that Report (referenced above) around the same time as activity time. But the requestID on the GatewayLogs are not same as on the PowerBI Admin API call for activities.

Kindly help me in identifying the traceability from PowerBI services to Gateway.

 

Additional Information: Data Source is SSAS server and On Prem Gateway is used to allow the interaction between SSAS and PowerBi Reports.

Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
v-yingjl
Community Support
Community Support
‎08-09-2021 12:23 AM

Hi @nimishnagpal13 ,

Which Admin rest API you are using in this issue? The below one or anything else?

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events

 

Consider sharing more details about this issue.

 

Best Regards,
Community Support Team _ Yingjie Li

nimishnagpal13
Frequent Visitor
‎08-16-2021 10:09 AM

I am trying to relate the powerBI activity with the Gateway logs. Please suggest what is the relationship between these 2 logs.

 

Report Name: KPI

Datasource : Analysis Server (On Prem SSAS)

Gateway : On prem GatewayCapture.PNG

 

Let me elaborate on my actions.

I viewed this report today and now looking at the Get Activity- Admin API  to find my VIEW activity on PowerBI Services. Found one here

Capture.PNG

 

Since this report is on On-Premises Analysis Server, the Gateway should receive the query triggered by the report. Now looking at the gateway log. I found the queries as well that were triggered.

Capture.PNG

Now, none of the ID available in the gateway matches the IDs available in the Activity logs from the powerBI Services.

Kindly suggest how to map these 2 logs with each other.

nimishnagpal13
Frequent Visitor
‎09-08-2021 12:59 AM

Hello @v-yingjl

 

Do you have an update on the above issue?

 

Kr.

 

 

Mentioning @PowerBI 

Idea Statuses