topic Re: Power BI API - Activity Events - Schema in Developer

Power BI API - Activity Events - Schema

kmedici — Fri, 07 Oct 2022 13:54:56 GMT

Hi,

We have recently extracted the Power BI API data for Activity Events which contains in excess of 100 columns.

I haven't been able to find anywhere that explains the columns, and whilst some seem self explanatory, I would rather not leave it down to guesswork.

Where is the schema for this data that will provide me with column descriptions?

Thanks
Kris

Re: Power BI API - Activity Events - Schema

lbendlin — Sun, 09 Oct 2022 01:21:05 GMT

Not sure what you are referring to. Doesn't seem to be related to Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

Re: Power BI API - Activity Events - Schema

kmedici — Mon, 10 Oct 2022 07:46:05 GMT

Hi there @lbendlin

If you navigate to the link, expand Admin and then see Get Activity Events section, this is the process we have followed to obtain data via Power BI REST API.

Now that we have the data from this API, I was wondering if a schema existed for it as some columns are ambiguous and, to effectively use our data, we would like some definition of what it actually means.

I have began creating my own schema, but would rather not leave it down to assumptions. Plus there may be some other useful information there which, without knowing what the data means, would otherwise be assumed as redundant.

Thanks 🙂

Re: Power BI API - Activity Events - Schema

lbendlin — Tue, 11 Oct 2022 01:17:21 GMT

Seems like they added this API call rather recently. Anyway, the return JSON listed for the examples seems to cover the entire schema?

Re: Power BI API - Activity Events - Schema

kmedici — Tue, 11 Oct 2022 07:48:06 GMT

Hi @lbendlin

I really apprecitae your responses here.

The JSON just returns only the column name and value. Ultimately, it would be great to know what the columns actually mean. Here is an example list of columns pulled from the API:

Id
RecordType
CreationTime
Operation
OrganizationId
UserType
UserKey
Workload
UserId
ClientIP
UserAgent
Activity
ItemName
WorkSpaceName
DatasetName
ReportName
DashboardName
OrgAppPermission.recipients
OrgAppPermission.permissions
CapacityId
CapacityName
SharingInformation
WorkspaceId
AppName
SwitchState
ObjectId
DatasetId
ReportId
DataConnectivityMode
DashboardId
Datasets
Schedules.RefreshFrequency
Schedules.TimeZone
Schedules.Days
Schedules.Time
ArtifactId
ArtifactName
ImportId
ImportSource
ImportType
ImportDisplayName

Are you familiar with any documentation that provides descriptions of what these columns mean / are driven from in Power BI? Whilst some of the columns are really self explanatory, others aren't.

Thanks again

Re: Power BI API - Activity Events - Schema

v-jianboli-msft — Tue, 11 Oct 2022 09:20:38 GMT

Hi @kmedici ,

According to my knowledge, if you want to know these columns well, you may need to dive into Power BI.

Here are several links about this issue, hope it would help you.

Please refer to:

Introducing the Power BI Activity Log | Blog de Microsoft Power BI | Microsoft Power BI

Track user activities in Power BI - Power BI | Microsoft Learn

About the Admin portal - Power BI | Microsoft Learn

Detailed properties in the audit log - Microsoft Purview (compliance) | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI API - Activity Events - Schema

kmedici — Tue, 11 Oct 2022 09:29:41 GMT

Hi @v-jianboli-msft thanks a lot for the above.

Based on my research and the help from you and @lbendlin it looks like Detailed properties in the audit log - Microsoft Purview (compliance) | Microsoft Learn is the closest thing that exists for what I'm after on this. It's still not 100% because it contains some columns which don't exist in the Activity Events data. Either way, I think this is what I have to settle for, for now.

Thanks again for your guys' help.

All the best,
Kris

Re: Power BI API - Activity Events - Schema

M0hamedFazil — Wed, 31 Jul 2024 05:48:56 GMT

hi @kmedici,

I'm also facing the same problem and looking to find out the entire schema. If you got any can you please share where I can Find one. Thanks

Regards
Fazil M