Power BI Usage Metrics Data set access online

Question

Hi All,&nbsp;So here is a requirement where in I require data set that is used by the Power BI usage metrics feature to find out the number of visits of users for various dashboards. I need to access this data set and export it to&nbsp;cloud blob storage service such as AWS S3 or Azure blob storage. How to achieve this? Please help (urgent).&nbsp;&nbsp;Thanks in advanceRegardsAishwarya

gilbertq · Answer

There might be a way to do this, but it will involve quite a few steps.&nbsp;You could create a Usage report for each App Workspace that you want to monitor.You can do this by creating the Usage Metrics report and then clicking on File and then Save As.So there will be one dataset per App WorkspaceThen ensure that you have got the Power BI Publisher for Excel installed.https://powerbi.microsoft.com/en-us/excel-dashboard-publisher/Then connect to each dataset that you created above in your single Excel Workbook.You could then consolidate all the datasets into one using Power Query and PowerPivot.Finally you could then use a product like Power Update which will enable you to then refresh the workbook for you manually.http://poweronbi.com/power-update/After which you can then take this workbook and consume it where ever you want to. Possibly even back into Power BI?

anonymous · Answer

aishwarya020793&nbsp;You can find audit log information in O365. See here for access methods. You will most likely have to create some sort of extraction process, but I don't know of a hard limitiation that prevents you from doing this.See here

aishwarya020793 · Answer

Anonymous&nbsp;Actually I am new to this so can you please suggest some mechanism with which I can export the data set to aws?&nbsp;Thanks,&nbsp;Aishwarya

v-huizhn-msft · Answer

Hi&nbsp;aishwarya020793,After research, you can use the Usage Metrics in Power Bi service.&nbsp;This&nbsp;feature gives you one-click access to key usage metrics for your dashboards and reports, allowing you to pinpoint how your end users are interacting with your content. Usage metrics are provided on dashboards or reports in the selected workspace. To get access to usage metrics data for a particular dashboard or report, you must:• Have edit access to that dashboard or report• Have a Pro licenseWhen you sign in with pro license, please select one dashboard and click "Usage Metrics", please see the following screenshot. You will get the usage metrics for that dashboard or report over the last 90 days. Usage metrics are presented as a pre-built report, so you can pin any of the report visuals to a dashboard, to monitor them more easily or share usage with others.&nbsp;To get even more out of usage metrics, you can use the “save as” feature to create a copy of the pre-built usage metrics.&nbsp;Please review the following articles, which describe Usage Metric clearly.Measure and magnify your impact with dashboard and report Usage Metrics for content creatorsMeasure and Magnify Your Impact with Usage Metrics for Dashboard and Report Authors&nbsp;Best Regards,Angelia

aishwarya020793 · Answer

Thanks&nbsp;v-huizhn-msft&nbsp;But I need to have access to the data set that is used for creating charts of usage metrics report. This data has to be exported autometically to S3. So can you please provide a mechanism for accesing the data set, I am already familiar with Usage metrics feature.&nbsp;RegardsAishwarya

Forum Discussion

Power BI Usage Metrics Data set access online

10 Replies

Related content

Accessing Fabric Capacity Metrics Semantic Model

Source Online Product S3 Contents Accessed/Downloads (GA5)?

Azure access for PowerBI online

Power BI Usage Metrics and Access Tracking

Usage Metric report Refresh Issue