Forum Discussion
List of Active Power Bi Pro Users
We are planning on purchasing Power Bi Premium as most of our 900+ Power Bi Pro users only use their license to view and not create. We expect, however, that we will still require around 100 Pro licenses for the dashboad / report creators.
The challenge I am faced with, in the process, is how to identify active dashboard / report creators from the 900+ Pro licenses we currently have, so that I know who needs to keep their Pro license and who doesn't?
The Power Bi admin panel seems very limited in the information it can give me and there aren't any export options to give me more insights into the dashboard / report creators.
1. How can I get an overview of Users that have created dashboards / reports?
2. Is there a way to see all dashboards created within the organisation and by whom?
3. Can I see view statistics of dashboards to that we can retire these?
Thanks for your support
Roderick
Hi. There is no way to check this in the UI. You will need to take a look at the Power Bi Rest API. Consider that the following requests are for a Power Bi Admin and when I say "Components" I mean dashboards, reports, datasets, dataflows and apps.
https://docs.microsoft.com/en-us/rest/api/power-bi/
In there you have different requests that might be able to help you. For example, you can ask for all datasets in the tenant like this: https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-as-admin
The response includes a "ConfiguredBy" that will specify which is the current owner of the component. That's the closest to created by you can get.
Then you can get a list of users with permission on that component like "Get[Component]UsersAsAdmin" like this: https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-dataset-users-as-admin
You can check users and permission for any component.
The last one, number 3, is the most complicated. You can build a historic data in a storage with the right scripts to capture the paginated response of the following api request: https://docs.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events
That request will help you understand the usage of the whole Power Bi Service (only last 90 days, you can store it to keep an historical).
I hope this helps,
1 Reply
- ibarrau
Super User
Hi. There is no way to check this in the UI. You will need to take a look at the Power Bi Rest API. Consider that the following requests are for a Power Bi Admin and when I say "Components" I mean dashboards, reports, datasets, dataflows and apps.
https://docs.microsoft.com/en-us/rest/api/power-bi/
In there you have different requests that might be able to help you. For example, you can ask for all datasets in the tenant like this: https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-as-admin
The response includes a "ConfiguredBy" that will specify which is the current owner of the component. That's the closest to created by you can get.
Then you can get a list of users with permission on that component like "Get[Component]UsersAsAdmin" like this: https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-dataset-users-as-admin
You can check users and permission for any component.
The last one, number 3, is the most complicated. You can build a historic data in a storage with the right scripts to capture the paginated response of the following api request: https://docs.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events
That request will help you understand the usage of the whole Power Bi Service (only last 90 days, you can store it to keep an historical).
I hope this helps,