Error while loading TenantOfficeServicePlan and TenantOfficeLicense

[bhushangawale]

Hi,

I have been trying to connect to Office 365 Reporting API i.e. https://reports.office.com/pbi/v1.0/<Tenant-Id> from Power BI desktop and trying to get the data out of it.

So far, I am able to connect to the service using correct credentials and can load all the resulting datasets except these two i.e. TenantOfficeServicePlan and TenantOfficeLicense. It always results into an error with below message while loading both these tables

DataSource.NotFound: OData: Request failed (404): The remote server returned an error: (404) Not Found.
Details:
DataSourceKind=OData
DataSourcePath=https://reportsweu.office.com/pbi/v1.0/{Tenant-GUID}/TenantOfficeLicense
Url=https://reportsweu.office.com/pbi/v1.0/{Tenant-GUID}/TenantOfficeLicense

Does anyone has any clue or have observed anything similar to this? 

[Kerry]

Hi guys i found a cause for that problem, it seems because office 365 has change the name of table in databse

But they did not update the default connecting setting in Odata Feed.

when you look at the actual queries Odata Feed used to get "TenantOffice License" it is:

--------------------------------------------------------------------------------------------------------------------------

let

    Source = OData.Feed("https://reports.office.com/pbi/v1.0/TanantId"),

    TenantOfficeLicense_table = Source{[Name="TenantOfficeLicense",Signature="table"]}[Data]

in

    TenantOfficeLicense_table

--------------------------------------------------------------------------------------------------------------------------

However, when you look at the template pbit file they provided

For the same table they want, the actual queirs is

--------------------------------------------------------------------------------------------------------------------------

let

    Source = OData.Feed("https://reports.office.com/pbi/v1.0/" & TenantID,null,[ODataVersion=4]),

    TenantOfficeActivation_table = Source{[Name="TenantOfficeActivation",Signature="table"]}[Data],

    #"Expanded ServicePlans" = Table.ExpandListColumn(TenantOfficeActivation_table, "ServicePlans"),

    #"Expanded ServicePlans1" = Table.ExpandRecordColumn(#"Expanded ServicePlans", "ServicePlans", {"ServicePlanName", "TotalEnabled", "TotalActivated", "TotalCount", "AndroidCount", "iOSCount", "MacCount", "PcCount", "WinRtCount"}, {"ServicePlanName", "TotalEnabled", "TotalActivated", "TotalCount", "AndroidCount", "iOSCount", "MacCount", "PcCount", "WinRtCount"}),

    #"Expanded Licenses" = Table.ExpandListColumn(#"Expanded ServicePlans1", "Licenses"),

    #"Expanded Licenses1" = Table.ExpandRecordColumn(#"Expanded Licenses", "Licenses", {"LicenseName", "AssignedCount"}, {"LicenseName", "AssignedCount"}),

    #"Removed Other Columns" = Table.SelectColumns(#"Expanded Licenses1",{"TimeFrame", "LicenseName", "AssignedCount"}),

    #"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"TimeFrame", type date}})

in

    #"Changed Type"

 --------------------------------------------------------------------------------------------------------------------------

I bold the table name they get, it is different.

I believe it is because they had change the name of table ,and the previous one does not exist anymore  

[Anonymous]

Did you resolve this?

I'm facing the same error

[v-qiuyu-msft]

Hi @bhushangawale,

In your scenario, it seems that you use OData data source to get data, right? Can you use Fiddler to capture trace and share .saz file here for our analysis?

Best Regards,
Qiuyun Yu

[bhushangawale]

Sharing the session request / response. PFA here.

[bhushangawale]

Any  update on this? The error seems to be persistent. Is there any other well-monitored channel where the details of the issue can be posted?

[v-qiuyu-msft]

Hi @bhushangawale,

Please use the enable the desktop trace then repeat the steps to get data till the error throws out. Share desktop trace file with us. Also please use Fiddler to capture http trace and share .saz file here.

Best Regards,
Qiuyun Yu