Forum Discussion

TheKiltedGolfer's avatar
TheKiltedGolfer
Helper III
7 years ago
Solved

Collecting Web Page data

Where I work we have a portal using a https url to Microsoft 365 Admin Center where we can view "Usage" reports for email, Skype, Office activations, etc.  I am sure many companies have this as well that use Microsoft products. I am trying to pull the data from the usage report web page via Get Data> Web but it fails and shows no data.  Is there another way to get this Microsoft data via "Get Data?"  I would have thought this would have played well since I am working with Microsoft products.

  • Hi TheKiltedGolfer ,

    It seems that you want to have an analysis for the Usage data in Office 365 Admin portal via Power BI.

    Actually, you could use the Microsoft 365 analytics Usage in Power BI Service to achieve it by my test. 

    Please follow this blog step by step.

    Best  Regards,

    Cherry

     

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi TheKiltedGolfer ,

    It seems that you want to have an analysis for the Usage data in Office 365 Admin portal via Power BI.

    Actually, you could use the Microsoft 365 analytics Usage in Power BI Service to achieve it by my test. 

    Please follow this blog step by step.

    Best  Regards,

    Cherry

     

    • TheKiltedGolfer's avatar
      TheKiltedGolfer
      Helper III

      Hello v-piga-msft,

       

      I just recently was able to gain access to the Microsoft 365 analytics Usage that Microsoft provides my employer.  I was able to copy their report and then produce my specific report from that.  Thanks again for your great suggestion !!!

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi TheKiltedGolfer ,

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please feel free to ask.

    Best  Regards,

    Cherry