Forum Discussion

aishwarya020793's avatar
aishwarya020793
Frequent Visitor
9 years ago

Power BI Usage Metrics Data set access online

Hi All,   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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

aishwarya020793 Is this the same question you already posted here?

aishwarya020793's avatar
aishwarya020793
Frequent Visitor
9 years ago

Yes Anonymous

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi aishwarya020793,

    Currently we can only export data from the report view to CSV and excel file directly. For your requirement, you can create a feature request here.

    Best Regards,
    Angelia

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      9 years ago

      There might be a way to do this, but it will involve quite a few steps.

       

      • 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 Workspace
      • Then ensure that you have got the Power BI Publisher for Excel installed.
      • 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.

      After which you can then take this workbook and consume it where ever you want to. Possibly even back into Power BI?