applicationInventories missing in Fields

[Anonymous]

I am looking to replace sccm reports with Power Bi reports.  I looked at this earlier and there was a very useful field called applicationinventories.  I can see it on the old pbix file but when I create a new pbix or reimport the Odata the applicationInventories  field is missing.  This field is essential to making useful reports for my organization.  Any idea what happened to this field?

[ChuckRose]

I realize this thread is old but I have just encountered this error as well and opened a ticket with Microsoft support.  They advised I needed to change the ?api-version=1.0 to api-version=beta ad the end of the Odatafeed query.

Use 

OData.Feed("https://fef.msua01.manage.microsoft.com/ReportingService/DataWarehouseFEService/applicationInventori..."

instead of 

OData.Feed("https://fef.msua01.manage.microsoft.com/ReportingService/DataWarehouseFEService/applicationInventori..."

Regards,
Chuck

[TANSHUAI]

Is work for me.

[v-shex-msft]

Hi @Anonymous ,

You can try to use old report to generate a template report file, then you can use exported template file with new connection string to generate new reports.

If above not help, can you please share some detail informations to help us clarify your scenario?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[Anonymous]

Any insight on this.  Otherwise can you show me how to create a report for All software on one device and one specific software on all devives without using the applicationInventories field?   Anyone else having this issue? 

[v-shex-msft]

Hi @Anonymous ,

Have you check their query table codes?(query editor-> advanced editor) If you copy old version code and create new query table on new pbix file, did these code worked?

If they works, it means new version odata feed connector driver has hidden some fields but you can try to use old driver to navigate to specific tables.

Regards,

Xiaoxin Sheng

[Anonymous]

I have tried that and I just get the same result.    The issue is when I Get data and load my Odata Feed the applicationInvenories Field is not available for selection.  The first picture is what I see.  The second picture is what I saw previously and what is shown for every walkthrough I see for adding the Odata Feed.

I need that field back.  What happened?  Where did it go?  How do I get it back?