Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

BUG: Audit Events for Scorecards Lack Identifying Information

TLDR;  The Audit Events for Scorecard related Activity lack identifying information (e.g. no ScorecardId, no GoalId, etc.)

 

Further Details Below: 

---

 

Created a scorecard with 1 goal

  • name: SC6.2
  • created at: 2023-07-04 at 8:24 AM
  • scorecard id: 38a65596-7301-405c-b4d6-0fd4b764630c
  • goal id (M1): d0f37ad5-30c5-4ffc-a404-7566af1494a7

 

Now wait 10 minutes or so, then use the REST API to query for the related Audit Events.   

 

There are audit events created for the Scorecard activity, but they lack the details required to correlate them with the corresponding scorecard (e.g. there needs to be fields like ScorecardId or ArttifactId that reference the Scorecard in question... same for Goal).   For example: 

 

{
  "activityEventEntities": [
    {
      "Id": "ac512f9b-a332-4be5-b177-1e172c0c9f31",
      "RecordType": 20,
      "CreationTime": "2023-07-04T13:24:56",
      "Operation": "GetScorecard",
      "OrganizationId": "41804690-0cf9-4b43-afc6-67bc92e9e340",
      "UserType": 0,
      "UserKey": "10032001A1A63B97",
      "Workload": "PowerBI",
      "UserId": "bob@acme.com",
      "ClientIP": "2600:1700:ee70:f390:29f9:ee7c:bd2b:24f9",
      "UserAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
      "Activity": "GetScorecard",
      "IsSuccess": true,
      "RequestId": "a5b94baa-e799-4aa8-b441-5b1735dbd505",
      "ActivityId": "389a3471-98f8-4b71-9594-ce2d50880cb3"
    },
    {
      "Id": "a8b27128-6e48-4a82-b199-db94247bbf8d",
      "RecordType": 20,
      "CreationTime": "2023-07-04T13:24:55",
      "Operation": "CreateScorecard",
      "OrganizationId": "41804690-0cf9-4b43-afc6-67bc92e9e340",
      "UserType": 0,
      "UserKey": "10032001A1A63B97",
      "Workload": "PowerBI",
      "UserId": "bob@acme.com",
      "ClientIP": "2600:1700:ee70:f390:29f9:ee7c:bd2b:24f9",
      "UserAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
      "Activity": "CreateScorecard",
      "IsSuccess": true,
      "RequestId": "08bfbe66-f7ce-4017-b2ac-b9c17222ea25",
      "ActivityId": "389a3471-98f8-4b71-9594-ce2d50880cb3"
    },
    {
      "Id": "f9aaa20c-ced5-42d4-843e-152b30beb02a",
      "RecordType": 20,
      "CreationTime": "2023-07-04T13:25:04",
      "Operation": "CreateGoal",
      "OrganizationId": "41804690-0cf9-4b43-afc6-67bc92e9e340",
      "UserType": 0,
      "UserKey": "10032001A1A63B97",
      "Workload": "PowerBI",
      "UserId": "bob@acme.com",
      "ClientIP": "2600:1700:ee70:f390:29f9:ee7c:bd2b:24f9",
      "UserAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
      "Activity": "CreateGoal",
      "IsSuccess": true,
      "RequestId": "c64e903a-db8c-4ff1-854e-403fe3f5de04",
      "ActivityId": "389a3471-98f8-4b71-9594-ce2d50880cb3"
    },
    {
      "Id": "95bbb611-c793-456d-a454-dc6e79432376",
      "RecordType": 20,
      "CreationTime": "2023-07-04T13:25:15",
      "Operation": "GetGoal",
      "OrganizationId": "41804690-0cf9-4b43-afc6-67bc92e9e340",
      "UserType": 0,
      "UserKey": "10032001A1A63B97",
      "Workload": "PowerBI",
      "UserId": "bob@acme.com",
      "ClientIP": "2600:1700:ee70:f390:29f9:ee7c:bd2b:24f9",
      "UserAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
      "Activity": "GetGoal",
      "IsSuccess": true,
      "RequestId": "112a219c-d1eb-4f01-ac7d-7492c5ee9373",
      "ActivityId": "389a3471-98f8-4b71-9594-ce2d50880cb3"
    },

 

Status: Needs Info

Hi @lhankins ,

 

I can't reproduce your problem, I haven't received any feedback from other users who have similar experience with you, can you add more information?

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Needs Info

Hi @lhankins ,

 

I can't reproduce your problem, I haven't received any feedback from other users who have similar experience with you, can you add more information?

 

Best Regards,
Community Support Team _ Caitlyn

lhankins
Regular Visitor

Steps to Reproduce: 

 

1. Createa  new Scorecard in a Workspace

2. Add a sample Measure to the Scorecard, e.g. 

 

lhankins_0-1688560033885.png

3. Interact with the Scorecard a bit (e.g. exit to the workspace, click back on the newly created Scorecard).

4. Now use the Power BI REST API to query for the Activity Events related to create / edit / read of the above Scorecard.  See API docs here:  REST API - Admin - Get Activity Events

 

* Note - you may have to wait a few minutes before the Activity Events are visible.

 

You will see activity events for the new Scorecard (as depicted in the initial post above).   

 

BUG: the Activity Events for Scorecards lack any reference to the specific Scorecard i.e. the Activity Events for Scorecards are missing the Scorecard ID.

 

For contrast, consider the Activity Event generated by viewing a Report. Note how it contains identifying information for the Report in question, e.g. "ReportId" in the example below:  

 

Activity Event for Viewing a Report: 

{
      "Id": "493aafbd-9fc9-4f20-8319-751c589d1971",
      "RecordType": 20,
      "CreationTime": "2023-07-04T13:33:46",
      "Operation": "ViewReport",
      "OrganizationId": "41804690-0cf9-4b43-afc6-67bc92e9e340",
      "UserType": 0,
      "UserKey": "10032001A1A63B97",
      "Workload": "PowerBI",
      "UserId": "bob@acme.com",
      "ClientIP": "2600:1700:ee70:f390:29f9:ee7c:bd2b:24f9",
      "UserAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
      "Activity": "ViewReport",
      "ItemName": "Report on SC6.2 Dataset",
      "WorkSpaceName": "Dev-6",
      "DatasetName": "SC6.2",
      "ReportName": "Report on SC6.2 Dataset",
      "CapacityId": "AC864DD6-11D4-48FE-A42F-4FEE897FFF90",
      "CapacityName": "Shared On Premium - Reserved",
      "WorkspaceId": "c8dbb465-911d-4406-a103-6be331f78c03",
      "ObjectId": "Report on SC6.2 Dataset",
      "DatasetId": "ddcd922e-160e-49da-a775-ba577215a8af",
      "ReportId": "34d51edb-6a23-4b67-9b6c-c07cfcf4ece2",
      "ArtifactId": "34d51edb-6a23-4b67-9b6c-c07cfcf4ece2",
      "ArtifactName": "Report on SC6.2 Dataset",
      "IsSuccess": true,
      "ReportType": "PowerBIReport",
      "RequestId": "05e5e9a1-29b7-b766-8979-241b08680f3c",
      "ActivityId": "be66a433-e06c-f91b-e687-1959f9832914",
      "DistributionMethod": "Workspace",
      "ConsumptionMethod": "Power BI Web",
      "ArtifactKind": "Report"
    }

 

kevingauv
Advocate II

You are write, at least... the workspaceid where the scorecard is store should be nice....

lhankins
Regular Visitor

@v-xiaoyan-msft - can you verify that you have what you need now and that this is not stuck in "NEEDS INFO"...?

 

Thanks!

Edwin_vm
New Member

@v-xiaoyan-msft, we experienced the same issue.