Forum Discussion

Chris_FSA's avatar
Chris_FSA
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Can't import data from Microsoft 365 Usage Analytics

I get the following error:

 

We couldn't import data from Microsoft 365 Usage Analytics

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

MessageThe credentials provided for the OData source are invalid. (Source at https://reports.office.com/pbi/v1.0/xxxxxxxxxxxxxxxxxxxx/TenantProductActivity.) Table: TenantProductActivity.

Activity ID46693bf4-67b9-77c6-81dd-fc0854be20ac

Correlation ID284d02e0-6dfe-0769-6fd4-a4cd8f10d50a

Request ID63bcb1bb-288d-6e16-37e1-2577388753e4

Status code400

TimeTue Jul 31 2018 16:20:40 GMT+0100 (British Summer Time)

Version13.0.6199.176

Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net

 

I've obfuscated our Tenant ID, not sure if I should have included it or not.

 

Not sure why this is happening but I've tried a few times to no avail.

4 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Chris_FSA,

    Based on my test, it could work on my side.

    The problem could due to you have provided the wrong credentials for the OData source. Please check if the account you entered is either a global administrator, report reader, Exchange administrator, Skype for Business administrator, or SharePoint administrator. 

    You could also refer to this link: https://support.office.com/en-us/article/enable-microsoft-365-usage-analytics-9db96e9f-a622-4d5d-b134-09dcace55b6a

     

    Regards,

    Daniel He

     

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Chris_FSA,

    could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

     

    Regards,

    Daniel He

    • Chris_FSA's avatar
      Chris_FSA
      Icon for Advocate I rankAdvocate I

      Sorry for the delay - I've only just been granted admin rights to our Sharepoint instance and can confirm that this has fixed this issue.

       

      Many thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable

        I have the same issue. I have the right as admin. But I can't import data. Same message. I can't fixe it.