Microsoft 365 usage

[nagarjunakan]

I am having problems loading the Microsoft 365 usage pbit in PowerBI desk top.

The error messages i am getting for most of the data is:

Load was cancelled by an error in loading a previous table

TenantClientUsage

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

TenantMailboxUsage

The following system error occurred:

TenantOfficeActivation

The following system error occurred:

TenantOneDriveUsage

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

TenantProductActivity

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

TenantProductUsage

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

TenantSharePointUsage

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

UserActivity

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

UserState

OLE DB or ODBC error: [DataSource.Error] OData: A supported MIME type could not be found that matches the content type of the response. None of the supported type(s) 'application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=false, application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=true, application/json;odata.metadata=minimal;odata.streaming=true, application/json;odata.metadata=minimal;odata.streaming=false;IEEE754Compatible=false, application/json;odata.metadata=minimal;odata.streaming=false;IEEE754Compatible=true, application/json;odata.metadata=minimal;odata.streaming=false, application/json;odata.metadata=minimal;IEEE754Compatible=false, application/json;odata.metadata=minimal;IEEE754Compatible=true, application/json;odata.metadata=minimal, application/json;odata.metadata=full;odata.streaming=true;IEEE754Compatible=false, application/json;odata.metadata=full;odata.streaming=true;IEEE754Compatible=true, application/json;odata.metadata=full;odata.streaming=true, application/json;odata.metadata=full;odata.streaming=false;IEEE754Compatible=false, application/json;odata.metadata=full;odata.streaming=false;IEEE754Compatib...' matches the content type 'text/html; charset=utf-8'..

TenantOfficeLicenses

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

SPO-UserActivity

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

TenantOneDrive-Activity

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

TenantOneDrive-Usage

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

TenantSharePoint-Activity

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

TenantSharePoint-Usage

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

ODBActive-Accounts/Users/Docs

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

SPO-SiteType

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

SPOActive-Sites/Users/Docs

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

RegionActivity

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

TopN

Load was cancelled by an error in loading a previous table.

[v-yiruan-msft · Accepted solution]

Hi @nagarjunakan，

If the above posts help you resolve your problem? If yes, could you please mark the helpful post as Answered? It will help other member in the community easier to find it if they face the similar problem with you. Thank you.

Best Regards

Rena

[amitchandak]

@nagarjunakan 

Refer

https://community.powerbi.com/t5/Desktop/Can-t-import-data-from-Microsoft-365-Usage-Analytics/m-p/47...

https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/enable-usage-analytics?view=o36...

[rajendraongole1]

Check the below link

https://www.youtube.com/watch?v=bmKYOiJt4EM

Hope it helpful.

[nagarjunakan]

Hi Rajendra 

iam tried but it will not work