Forum Discussion
Usage and Adoption
Hello. Does anyone know how to get the data from the usage data from PBI service? I go to the Fabric admin reports, and when I click to export to Excel, the data doesn't export. I rather not go the REST API option. Any information would be much appreciated. Thank you!
Hi lnewell ,
You stated that you do not want to go to the Rest API. So, there are several locations for logs though within your tenant and within the workspaces themselves.
The tenant level O365 logs can be quite helpful. Here are a couple of links for that:
Customize the reports in Microsoft 365 usage analytics - Microsoft 365 admin | Microsoft Learn
Build Your Own Power BI Audit Log; Usage Metrics Across the Entire Tenant - RADACAD
In Power BI Workspaces, you have the usage metrics report:
Monitor report usage metrics - Power BI | Microsoft Learn
Also, if you have "monitoring" for workspaces turned on, there is a great newer tool that does that as well:
Enable workspace monitoring - Microsoft Fabric | Microsoft LearnHi lnewell ,
I want to confirm weather you are trying to export usage metrics report to Excel
If Yes, please ensure all these prerequisites are met
These conditions must be met if we want to Export to Excel.
Reference for the above points can be found here: Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn
Also another important point to consider is Usage metrics are only available for reports in Workspaces that are on Premium or Pro licenses and not in a personal workspace (My Workspace).
Check out the prerequisites of usage metrics as well:
Monitor report usage metrics - Power BI | Microsoft Learn
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards
5 Replies
Hi lnewell ,
You stated that you do not want to go to the Rest API. So, there are several locations for logs though within your tenant and within the workspaces themselves.
The tenant level O365 logs can be quite helpful. Here are a couple of links for that:
Customize the reports in Microsoft 365 usage analytics - Microsoft 365 admin | Microsoft Learn
Build Your Own Power BI Audit Log; Usage Metrics Across the Entire Tenant - RADACAD
In Power BI Workspaces, you have the usage metrics report:
Monitor report usage metrics - Power BI | Microsoft Learn
Also, if you have "monitoring" for workspaces turned on, there is a great newer tool that does that as well:
Enable workspace monitoring - Microsoft Fabric | Microsoft LearnHi lnewell ,
I want to confirm weather you are trying to export usage metrics report to Excel
If Yes, please ensure all these prerequisites are met
These conditions must be met if we want to Export to Excel.
Reference for the above points can be found here: Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn
Also another important point to consider is Usage metrics are only available for reports in Workspaces that are on Premium or Pro licenses and not in a personal workspace (My Workspace).
Check out the prerequisites of usage metrics as well:
Monitor report usage metrics - Power BI | Microsoft Learn
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and RegardsHi lnewell
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi lnewell ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi lnewell ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Thanks and regards