topic Re: Get RLS activity in usage metric report in Developer

Get RLS activity in usage metric report

Sanjzzzz — Mon, 29 Jul 2024 11:59:36 GMT

Dear community,

I have a included Norway, Taiwan and other countries RLS in many of my reports. I'm supposed to create usage metric report which shows "how many people from Norway use the report."

Is there any way to get such data in the usage metric report?

Please help. My humble request.

Re: Get RLS activity in usage metric report

Sanjzzzz — Mon, 29 Jul 2024 12:12:01 GMT

@lbendlin please help

Re: Get RLS activity in usage metric report

Anonymous — Tue, 30 Jul 2024 05:46:45 GMT

Hi @Sanjzzzz ,

Based on my research, there is currently no direct method to capture Row-Level Security (RLS) activities within the usage metric reports in Power BI. However, you can follow the steps below to get it as a workaround:

1. Create and view a new usage metrics report

Solved: Re: How to fetch usage metric details through Powe... - Microsoft Fabric Community

Admin - Get Activity Events - REST API (Power BI Power BI REST APIs) | Microsoft Learn

2. Customize the Usage Metrics Report

3. Open the aboved copied report in Power BI Desktop and add RLS info in it

4. Create the measures to get the user info from different regions base on RLS role and usage metric info

5. Save and publish the updated report to Service

Best Regards

Re: Get RLS activity in usage metric report

mariussve1 — Sat, 03 Aug 2024 08:31:46 GMT

Hi,

It is possible to achieve this if you use Log Analytics. I have developed a very good solution using Pipelines, Notebooks, API, and Log Analytics.

It requires quite a bit of work and is not entirely straightforward, but I have managed to create a very good solution.

I combine this with the Activity Event API, so I now have a detailed log per user down to each individual page visited. Log Analytics logs all queries, so it can also be easily adapted to see which RLS rule is used.

Im also from Norway 🙂