Forum Discussion
Notebook semantic link (sempy) extract report usage
Already found it 🙂
This works for me:
import sempy.fabric as fabricimport jsonmethod = 'GET'start_time = "'2024-12-11T00:55:00.000Z'"end_time = "'2024-12-11T12:00:00.000Z'"filter = "$filter=Activity eq 'viewreport'"query = '&'.join(['startDateTime='+start_time,'endDateTime='+end_time,filter])full_url = url + '?' + queryclient = fabric.PowerBIRestClient()def get_activity_events(url😞response = client.request(method, url)data = response.json()# Process the current batch of eventsevents = data.get('activityEventEntities', [])# Check for continuationcontinuation_uri = data.get('continuationUri')while continuation_uri:response = client.request(method, continuation_uri)data = response.json()events.extend(data.get('activityEventEntities', []))continuation_uri = data.get('continuationUri')return eventsevents = get_activity_events(full_url)print(json.dumps(events, indent=4))
Hi spencer_sa,
I got the data from the tables you adviced and loaded them into my lakehouse.
Now next step is to understand how I can get the report usage from that data. Should these be specific items? I guess it would only work if the reports are also in a workspace with fabric capacity?
SnoekLaurens, I don't think the semantic model that powers the Report Usage is directly accessible right now. One another way I would think of is using the REST API Get Activity Events (requires admin role though). But it is not as detailed as Report Usage, for e.g. getting the page level information is not possible.
But calling a PBI REST API is much easier in Spark notebook inside Fabric, as you can get the token using mssparkutils.
import requests
from pyspark.sql import SparkSession
import json
from notebookutils import mssparkutils as msu
def pbi_rest_api(method, uri, payload=None):
"""
Makes a REST API call to Power BI. Token is automatically generated from mssparkutils based on the user id running the notebook
Args:
method (str): The HTTP method ('GET' or 'POST').
uri (str): The later part of the REST API URL.
payload (dict): The payload, if it is a POST request.
Returns:
Response object: The response from the REST API.
"""
endpoint = "https://api.powerbi.com/v1.0/myorg"
url = f"{endpoint}/{uri}"
headers = {
"Authorization": "Bearer " + msu.credentials.getToken("pbi"),
"Content-Type": "application/json"
}
session = requests.Session()
try:
response = session.request(method, url, headers=headers, json=payload, timeout=120)
response.raise_for_status()
return response.json()
except Exception as e:
print(f"Exception raised {e}")
What do I need to add to get the results correctly shown in a dataframe?
My results don't seem to be the report views but it shows me the continuationToken
Already found it 🙂
This works for me:
import sempy.fabric as fabricimport jsonmethod = 'GET'start_time = "'2024-12-11T00:55:00.000Z'"end_time = "'2024-12-11T12:00:00.000Z'"filter = "$filter=Activity eq 'viewreport'"query = '&'.join(['startDateTime='+start_time,'endDateTime='+end_time,filter])full_url = url + '?' + queryclient = fabric.PowerBIRestClient()def get_activity_events(url😞response = client.request(method, url)data = response.json()# Process the current batch of eventsevents = data.get('activityEventEntities', [])# Check for continuationcontinuation_uri = data.get('continuationUri')while continuation_uri:response = client.request(method, continuation_uri)data = response.json()events.extend(data.get('activityEventEntities', []))continuation_uri = data.get('continuationUri')return eventsevents = get_activity_events(full_url)print(json.dumps(events, indent=4))