Hi, does anyone know if there is a way to use Python semantic link package to extract report usage form all reports that are in a workspace or connected to a certain shared dataset in power bi Service?Or is there any other good alternative to do this easily?

Already found it 🙂 This works for me: import sempy.fabric as fabricimport jsonmethod = 'GET'url = 'https://api.powerbi.com/v1.0/myorg/admin/activityevents'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 events events = data.get('activityEventEntities', []) # Check for continuation continuation_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))

Notebook semantic link (sempy) extract report usage

Forum Discussion

Related content

SEMPY - Remame Column Semantic Model

Executing MDX queries in a fabric notebook (via pyadomd or sempy)

Sempy Labs : Create Shortcut

Updating Semantic Models in Notebooks with Semantic Link

notebook parameter