Help Premium licensing decission - get list of users who only view Dashboards and reports

[Anonymous]

I am trying to analyse the PBI Audit log data to get some numbers. I am struggeling to get the list of user ids that are only viewing the reports and dashboards and are not developers. Here is some sample data.  111,222 create and view but 333 only views reports or dashboards.

This number is going to help us figure out number for Fequent and Occational users when we move to Premium licensing.

UserID	Activity
111@abc.com	Create Report
222@abc.com	Create Dashboard
333@abc.com	view Report
111@abc.com	view Report
222@abc.com	view Report
333@abc.com	view Report

I just want to get

1. list of users who just view (333@abc.com )

2. to make it more relevant count agains the view only users to count number of times the users viewed will help even better (

( UserID             Count

  333@abc.com      2     ).

[Anonymous]

Hi @Anonymous,

You can configure filters by Activity in your Table Visual, showing only visualization activities.

Regards.

[Anonymous]

That would surely give me list of users with View Activity. If you see my example I just want the uers who are only viewing not the users who are develope and also view.

User1: I dovelope a dashboard and publish and then view online (then i dont myself to be listed)

User2: never developed any dashboard but views dashboards shared to him (I wan this user to be listed)

in my example on the post i want the output to show - 333@abc.com only (with two activitys of View...)

[Anonymous]

@Anonymous in this case try this:

In Query Editor, duplicate your table, filter one table by the viewers activities and the other by the developers activities.

               

Make a merge of the two tables by UserID, expand only the activity of the developers table and create a custom column with the following code:

if (([Activity] <> null) and ([Developers.Activity] = null)) then 1
else 0

Users with this new column in 1 are those who only view reports/dashboards.

Regards.

Note: Remove duplicates, in the original Table there are two 333@abc.com with View Report activity

[Anonymous]

Thanks FelipeLima for your replu. I tried it on sample dataset and it worked like a charm.

But when  I tried to impliment it on the PBI Audit logwith 60 months worth of data. It is throwing an error.

  

does the data volume cause the issue? i spent over 2 hours to redo the whole thing but no luck.