Service statistic on Page usage

[Olivierln]

Dear colleagues,

My objective here is to build a report and semantic model that goes behind the classic "power bi usage reports".

As of know, we are using the following Activity Log (https://learn.microsoft.com/fr-fr/power-bi/guidance/admin-activity-log#example-1-authenticate-with-t...), but there is no detail of the Report page people view. 

Is there any way to go below, and add the details of the page the report is looking at.

Thanks for you help !

[mariussve1]

Hi,

If you think my answer provided some kind of a soulition, please consider accepting it as soulition and click the button. I also greatly appreciate if you give me a kudos 🙂

Br

Marius

[Olivierln]

Hi, 
Thanks for you feedback. 
but here it seems like we are discussing the Metadata not the activity log (xxxx@gmail.com views the page xxx of the report yyy), isn 'it ?

[mariussve1 · Accepted solution]

Hi again,

When you turn on logging to Log analytics workspace in Power BI it will log almost everything.

You can customize the extract, so it returns exactly what you want. In my project I use this KQL:

PowerBIDatasetsWorkspace
| where TimeGenerated >= startofday(ago(1d)) and TimeGenerated < startofday(ago(0d))
| extend ParsedContext = parse_json(ApplicationContext)
| extend DatasetId = tostring(ParsedContext.DatasetId)
| where isnotempty(DatasetId)
| extend ReportId = tostring(ParsedContext.Sources[0].ReportId)
| extend VisualId = tostring(ParsedContext.Sources[0].VisualId)
| extend UserSession = tostring(ParsedContext.Sources[0].HostProperties.UserSession)
| where isnotempty(UserSession)
| extend DateTime = bin(TimeGenerated, 1m)
| extend Date = format_datetime(TimeGenerated, 'yyyy-MM-dd')
| summarize Sessions = dcount(UserSession) by
Date,
DateTime,
PowerBIWorkspaceId,
PowerBIWorkspaceName,
DatasetId,
ReportId,
VisualId,
ExecutingUser,
UserSession

Then you can connect this to the ActivityEvent API if you like. The KQL returns:

As you can see, this returns one row for each sessionid pr visual id that the end user have visited 🙂 This is just what you want.

Br
Marius

[mariussve1]

Hi,

I have started on this project myself, and its not strait forward, but doable.

First you need to do is enable logging to Log analytics:

https://learn.microsoft.com/en-us/power-bi/transform-model/log-analytics/desktop-log-analytics-overv...

Log analytics fetch the visual id. To map this the correct page you need to use an api to Get report definition:

https://learn.microsoft.com/en-us/rest/api/fabric/articles/item-management/definitions/report-defini...

Im using notebook and a Python script to convert the respons:

"payload": "base64 encoded string

I save this json respons to a file on onelake and Then use a new pythoncript to scan and Get all the visual id and wich page it belongs to.

Then at last I load the kql query from log analytics with the relevant info and map it to the Python extraction in power bi and create a report.

As I said, not Strait forward but doable.

Br

Marius 🙂